Perform the following steps on the database server computer.
-
Open Microsoft SQL Server Management Studio and expand your database server in the left tree view.
-
Expand the list under Security in the left tree view.
-
In the left pane, right-click Logins.
-
Select New Login from the shortcut menu.
-
On the Login - New dialog, type the user account you want to be assigned administrative privileges in the Login name text box. For example, type AdminUser1.
-
Select Server Roles under the Select a page heading to display the Server Roles list.
-
In the Server Roles list, for an administrator user select the sysadmin and public check boxes. For a standard user, select the public role only. By default, users with sysadmin privileges have administrator rights to all databases.
-
Select OK.
-
To assign permissions for a user or a group of users, follow steps 10 to 14.
-
Select User Mapping under the Select a page heading to display the Users mapped to this Login list.
-
Select the Map check box for one of the seven databases containing a Smart 3D project.
-
Specify the database roles using the Database role membership list:
For an administrator user, select db_owner and public.
For a standard user, select public, db_datareader, and db_datawriter.
-
For a standard user, right-click the database name and select Properties.
-
Select the user login and on the Permissions, select the Explicit tab and grant Execute.
-
Select the Effective tab and check that the standard user has the permission: CONNECT, DELETE, EXECUTE, INSERT, SELECT, UPDATE permissions.
The six permissions above are required. A user might have additional permissions but they are not required for a Smart 3D standard user.
-
-
Select OK.
-
Repeat the procedure for each of the remaining six databases.