Installation Guide › Installing CA Virtual Assurance › How to Adjust SQL Server User Permissions to the Required Minimum › (Optional) Consider the SQL Server User Permissions when Upgrading the Product

(Optional) Consider the SQL Server User Permissions when Upgrading the Product

The previously described SQL Server user permissions must include the db_owner role membership to support the upgrade of CA Virtual Assurance.

Verify, that the system\administrator or sa database user has the following permission:

• db_owner role membership for aom2 and dpm databases

The SQL Server user for CA Virtual Assurance is specified through the installation wizard and depends on the selection of SQL Server Authentication or Windows Authentication. The SQL Server user requires at least the following permissions for aom2 and dpm databases to support an upgrade:

• db_datareader role membership
• db_datawriter role membership
• EXECUTE permission
• db_owner role membership

After a successful upgrade, you can remove the db_owner role membership from the database user, because it is not required for normal operations.