![]() |
Telelogic System Architect (steve huntington) | ![]() |
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 |
![]() |
![]()
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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.
|
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
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 ![]() |
|
![]() |
|
![]() |
|
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" |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.