Assigning catalog access rights for SQL Server by using SQL scripts

Installing : Installing System Architect : Post‑installation tasks : Configuring user access rights to servers, catalogs, and encyclopedias : Assigning catalog access rights for SQL Server by using SQL scripts

After you create a TelelogicEnterpriseCatalog database, you can use SQL scripts that are installed with System Architect to provide the necessary rights for the database.

1 If the SAUSer role, which is intended for standard users, has not been created on the server, run this script:

use TelelogicEnterpriseCatalog
create role SAUSER

2 In Windows Explorer, navigate to the location of the SQL scripts, typically:

C:\Program Files\UNICOM Systems\System Architect Suite\System Architect\SQLServer

3 To grant rights to the tables in the catalog for a user, run the sqlCatalogGrant.sql script.

This script contains the rights that users of the catalog database need.

There are no stored procedures or functions for this type of database.

4 Assign login IDs to the SAUSER role.