Assign System Administrator Privileges for SQL Server 2012 - CADWorx - Installation & Upgrade

CADWorx Structure Installation Guide

PPMProduct
CADWorx
PPMCategory_custom
Installation & Upgrade
Version_CAESAR
12
Version_CADWorx
20.0 (2020)
Version_CADWorxStructure
2020(4.0)

Perform the following steps on the CADWorx 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 CADWorx 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.