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: Multi-Admin of Catalog Manager
Topic Summary: How to acieve multi-admin of Catalog Manager
Created On: 22-Apr-2008 14:23
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.
 22-Apr-2008 14:23
User is offline View Users Profile Print this message


Arif Hussain

Posts: 5
Joined: 10-Apr-2008

Hi,

Is there anyone out there who has more than one user looking after Catalog Manager?

If so, how do you grant permissions to the second user, without assigning him some server role?

Thanks

Arif Husain

Edited: 15-May-2008 at 17:22 by Arif Hussain
Report this to a Moderator Report this to a Moderator
 9-May-2008 16:03
User is offline View Users Profile Print this message


Andrea Heithoff

Posts: 33
Joined: 15-Aug-2005

In the catalog manager under each user is a value called "Catalog Permissions". if you click on this the user's permission to modify the catalog will be shown. To have more than one user make changes, just change the additional user rights by right clicking on CatalogAccess and choosing Properties. The user will also need to be authorized to edit the TelelogicEnterpriseCatalog database in your server, but this should be no different than a regular user of SA.
Report this to a Moderator Report this to a Moderator
 12-May-2008 11:57
User is offline View Users Profile Print this message


Arif Hussain

Posts: 5
Joined: 10-Apr-2008

Andrea,

The TelelogicEnterpriseCatalog database is not any normal SA database.
Having all the permissions and being a Catalog Administrator is not enough to be able to asccess it via Catalog Manager, if you are the secondary administrator.

You need to have sysadmin permissions on the whole server, which the company DBA administrator may object to, if the server is not totally dedicatd to SA, as is my case.
Report this to a Moderator Report this to a Moderator
 12-May-2008 15:30
User is offline View Users Profile Print this message


Andrea Heithoff

Posts: 33
Joined: 15-Aug-2005

In my previous project I was not a sysadmin to the server but was the catalog administrator. I believe I had just dbReader and dbWriter permissions to the catalog's database.

Our tools group did work with the server administrators for the user maintenance process though--they defined the new user on the server and assigned them to the designated SA User's server group as well as ensuring the SA User's server group was given the roles of dbReader, dbWriter, and SAUser (per SAEM) for all encyclopedias and some level of access to the catalog. The catalog administrators were empowered via catalog manager to then create the user and assign them a role in the appropriate encyclopedias. Dividing the work this way meant that the tools group had full ownership of the nature of access and the server administrators did not relinquish sysadmin rights but also did not have to do much at all to help us out.

So we're both right... but specific to the Catalog Manager element you do not have to be an administrator.
Report this to a Moderator Report this to a Moderator
 14-May-2008 15:23
User is offline View Users Profile Print this message


Arif Hussain

Posts: 53
Joined: 22-Dec-2005

According to the documentation

"You can also grant a role named Administrator to System Architect users that will allow them full permissions to create and manage catalogs."

Furthermore, it states

"For full access to the Catalog on the SQL Server the user must be given db_ddladmin, db_datareader, and db_datawriter for the TelelogicEnterpriseCatalog database."

Apart from that, I have the db_owner role.

But, as a secondary catalog administrator, the error message says I have insufficient permission to open the catalog.

What else do I need to do
Report this to a Moderator Report this to a Moderator
 23-May-2008 13:48
User is offline View Users Profile Print this message


Arif Hussain

Posts: 53
Joined: 22-Dec-2005

Problem solved.
Required following 2 steps to be carried out by an administrator to resolve problem:

1) Permission to "VIEW SERVER STATE" in the master database
2) Permission - execute on sp_lock in the master database.

eg

grant view server state to "HERXXX\user01"
grant execute on sys.sp_lock to "HERXXX\user01"
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.