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
  
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.
See also
Configuring user access rights to servers, catalogs, and encyclopedias