Assigning encyclopedia 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 encyclopedia access rights for SQL Server by using SQL scripts

System Architect is installed with SQL scripts that you can use to create the necessary tables, procedures, and functions of the encyclopedia database, and a script to assign the rights to these items.

1 To assign standard user rights to a user login ID, run the sqlRights.sql script.

The scripts for Microsoft SQL Server are typically in:

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

2 To assign administrator rights to a user login ID, after using the scripts for a standard user, run the following query:

USE <encyclopedia_name>
GO
EXEC sp_addrolemember db_owner, <login>
GO

3 To assign database administrator rights to a user login ID, run the following additional query:

EXEC master..sp_addsrvrolemember @loginame = N'<login>', @rolename = N'dbcreator'
GO