Assign System Administrator Privileges for SQL Server 2016 - Intergraph Smart 3D - Installation & Upgrade

Intergraph Smart 3D Installation

English (United States)
Intergraph Smart 3D
Search by Category
Installation & Upgrade
Smart 3D Version
12.1 (2019)

Perform the following steps on the Smart 3D database server.

  1. Open Microsoft SQL Server Management Studio and expand the listing for your database server in the left tree view.

  2. In the tree view, expand the listing under Security, right-click Logins, and select New Login.

    The Login - New dialog box displays.

  3. Type the user account to be assigned administrative privileges in the Login name text box. For example, type AdminUser1.

  4. Select Server Roles under the Select a page heading to display the Server Roles list.

  5. 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.

  6. Click OK.