Assigning encyclopedia access rights for SQL Server by using System Architect Encyclopedia Manager
You can use System Architect Encyclopedia Manager (SAEM) to create and edit roles for users of Microsoft SQL Server, and then assign rights to the roles.
To create the database role that is associated with standard users
1 In System Architect Encyclopedia Manager, connect to the local server: click Server > Connect, select the server, and click OK.
2 To select a database on the local server, click Database > Select Database, select the database, and then click OK.
3 Click Tools > Create SAUser Role.
4 The operation result is displayed in the Message Center window. If the SAUser database role already exists in the database, a message is displayed in the window.
To assign standard user rights to a server login ID
1 Click Server > Logins; then double-click the login name to which to add access rights.
2 In the Login Properties dialog box, click the Database Access tab and select the database to add the SAUser role to.
Although the database name might be highlighted in the dialog box, you must select the database name again to populate the available roles for the database.
3 In the Database roles for database_name section, select SAUser.
4 Click OK.
The SAUser role gives the user db_datareader and db_datawriter rights, which are predefined database roles. The role also provides the necessary rights on tables and the EXEC rights on any stored procedures and functions.
5 To upgrade encyclopedias when a database schema changes, a user needs the standard user rights and an additional database role named db_ddladmin.
To assign System Architect administrator rights to a server login, do this:
▪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 the database to add the administrator rights to.
Although the database name might be already highlighted, you must select the database name again to populate the available roles for the database.
▪In the Database roles for database_name section, select SAUser and db_ddladmin, and then click OK.
6 To create encyclopedias, a user needs administrator rights and an additional server role named dbcreator. Therefore, to assign database 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 Server Roles tab.
▪In the Server roles section, select dbcreator, and then click OK.