Assign System Administrator Privileges for SQL Server 2019 - Intergraph Spoolgen - Installation & Upgrade - Hexagon PPM

Spoolgen Web API Installation and Configuration

Language
English
Product
Intergraph Spoolgen
Search by Category
Installation & Upgrade

Perform the following steps on the Spoolgen Web API database server.

  1. Open Microsoft SQL Server Management Studio, and then 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 then select New Login to open the Login - New dialog.

  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 Spoolgen Web API databases. Standard users also need Execute permission to each database.

    • We do not recommend giving standard users db_owner permissions as it gives the users a very high privilege to the database.

  6. Click OK.