Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: Catalog Manager: How to make group/person Read Only?
Topic Summary: Cannot get model fully working in Catalog Mgr with existing docs
Created On: 2-May-2007 20:18
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 2-May-2007 20:18
User is offline View Users Profile Print this message


Kirk Walker

Posts: 32
Joined: 18-Sep-2004

The instructions in the help files for 10.4.23 reflect an older version of SA and the options to select no longer exist... but anyway.

I have defined myself (SQL server administrator) as having access to this one encyclopedia with Administrator role and it works fine...

For everyone else, I cloaned the Write Only role and called the copy "Read Only". I edited all of the "Permissions" and changed them from "W" to "R".

I then put an entire domain group as a User/Group, and gave them the Read Only role. A member of that group got an error saying: "There is no catalog on SQL server <> that you have permission to access."

I tried going into SQL Enterprise Manager and adding that group as a user of the database... that didn't work either... so I added the user explicitly to the Users & Groups in CM... and then when that didn't fix it, into the user list of the db itself.

How do I set them to read only AND, do I have to add users using Catalog manager AND SAEM/SQL Enterprise Manager or Just Catalog Manager.

Edited: 2-May-2007 at 22:51 by Kirk Walker
Report this to a Moderator Report this to a Moderator
 14-May-2007 19:38
User is offline View Users Profile Print this message


robert mccauley

Posts: 22
Joined: 19-Jun-2006

 



Edited: 14-May-2007 at 19:39 by robert mccauley
Report this to a Moderator Report this to a Moderator
 17-May-2007 20:36
User is offline View Users Profile Print this message


Jim Kerr

Posts: 4
Joined: 17-May-2007

Userid guest is special in SA Catalog Manager for readonly capability.  Add the user "guest" to the list of users in SA Catalog Manager.  Then add to guest to the list of other users in the readonly user/group.

Use SQL Enterprise Manger to add the guest userid to the SA Encyclopedia db you want to make read only.  User guest will need public, db_owner, and SAUser permission against the encyclopedia.  The actual users only require user accounts on the database server.  For readonly they do not require permission against the encyclopedia db as long as the guest userid is in Catalog Manager.

Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.