Enterprise Vault™ Using SQL Database Roles in Enterprise Vault, Compliance Accelerator, and Discovery Accelerator

Changing ownership of Compliance Accelerator and Discovery Accelerator databases

After a normal installation or upgrade of Compliance Accelerator and Discovery Accelerator, the Vault Service account owns their databases. As a result, the Vault Service account is a member of the db_owner fixed database role, which is not required for normal daily operations.

Use the following procedure and run one of these queries against each Compliance Accelerator and Discovery Accelerator database, to assign ownership to another privileged user. Choose the procedure that is appropriate for your version of SQL Server.

use CADADatabase
GO
ALTER AUTHORIZATION ON
DATABASE:: CADADatabase TO [domain\privileged_user];

or

use CADADatabase
GO
EXECUTE sp_changedbowner 'domain\privileged_user'

Where:

CADADatabase is the name of the Compliance Accelerator or Discovery Accelerator database.

domain\privileged_user is the privileged user and the domain to which it belongs.