Perform the following steps on the Smart 3D database server.
-
Open Microsoft SQL Server Management Studio and expand the listing for your database server in the left tree view.
-
In the tree view, expand the listing under Security, right-click Logins, and select New Login.
The Login - New dialog box displays.
-
Type the user account 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, select the sysadmin check box.
-
Administrators need the sysadmin role. Standard users need public, db_datareader, and db_datawriter database role membership mapping to each one of the Smart 3D databases. Standard users also need Execute permission to each database.
-
We do not recommend granting standard users db_owner permissions as it gives the users a very high privilege to the database.
-
-
Click OK.