Assigning catalog access rights for SQL Server by using System Architect Encyclopedia Manager
When you create a catalog with System Architect Catalog Manager (SAEM), you create a special database that contains the access permissions for each role for each encyclopedia. Users access the TelelogicEnterpriseCatalog database, to retrieve information in enterprise encyclopedias based on their role. You can use System Architect Encyclopedia Manager to assign catalog access rights for users of Microsoft SQL Server.
All the permissions that need to be granted for a catalog are contained in thesqlCatalogGrant.sql script file, which is located in the default installation path:
The script contains the following required entries:
USE master GRANT VIEW SERVER STATE TO SAUser GRANT EXECUTE on sp_lock TO SAUser
1 To connect to the local server and select the catalog database, complete the following steps:
▪In System Architect Encyclopedia Manager, connect to the local server: click Server > Connect, select the server, and click OK.
▪To select the TelelogicEnterpriseCatalog database on the local server, click Database > Select Database, select the database, and click OK.
2 To assign standard user rights to a server login ID, complete the following steps:
▪Click Server > Logins; then double-click the login name to which to add access rights.
▪In the Login Properties dialog box, click the Database Access tab and select TelelogicEnterpriseCatalog.
▪In the Database roles for database_name section, select the check box beside db_datareader.
▪Click OK.
3 Administrators of the catalog need standard user rights and two additional database access roles named db_datawriter and db_ddladmin. Therefore, to assign administrator rights to a server login ID, complete the following steps:
▪Click Server > Logins; then double-click the login name to which to add access rights.
▪In the Login Properties dialog box, click the Database Access tab and select TelelogicEnterpriseCatalog.
▪In the Database roles for database_name section, select these roles:
db_ddladmin
db_datareader
db_datawriter
▪Click OK.
4 To create catalogs, a user needs administrator rights and an additional server role named dbcreator. Therefore, to assign database administrator rights to a server login, complete the following steps:
▪Click Server > Logins; then double-click the login name to add access rights to.
▪In the Login Properties dialog box, click the Server Roles tab.
▪In the Server roles section, select dbcreator, and then click OK.