Installation Guide › Plan Your Installation › How to Adjust SQL Server User Permissions to the Required Minimum › Adjust the Permissions of the New Database User to the Required Minimum

Adjust the Permissions of the New Database User to the Required Minimum

CA Server Automation requires a database user with sufficient permissions to use the aom2 and dpm databases. This procedure describes how to adjust these permissions to a minimum.

Follow these steps:

1. In the SQL Server Management Studio, expand Security, Logins in the Object Explorer.
2. Right-click the new user (for example, causer) and open Properties, User Mappings.

   The User Mapping dialog appears.

3. Select the aom2 and dpm databases in the dialog and assign db_datareader and db_datawriter role memberships to both databases. Click OK.
4. Click New Query.

   The SQL console opens.

5. Enter the following SQL commands to allow the new database user (causer) the execution of stored procedures:

   use dpm
   GRANT EXECUTE TO causer
   use aom2
   GRANT EXECUTE TO causer
   

6. Right-click the new user (causer) in the Object Explorer and open Properties, Server Roles.

   The Server Roles dialog appears.

7. Remove the db_creator role and click OK.

   The new database user provides sufficient permissions to CA Server Automation to use the aom2 and dpm databases.