Return
-
Title
What are the minimum SQL rights required to run Change Auditor? -
Description
The documents state the following permissions are required for Change Auditor, but what are the absolute minimum rights needed to run Change Auditor?
MINIMUM PERMISSIONS FOR VERSION 5.x:
SQL Server database access account specified during installation:An account must be created to be used by the Coordinator service on an ongoing basis for access to the SQL Server database. This account must have a SQL Login and be assigned the following SQL permissions:
- Must be assigned the db_owner role on the ChangeAuditor database
- Must be assigned the SQL Server role of db_creator
- Must be assigned the following database roles in the msdb database:
- db_datareader
- db_datawriter
- SQLAgentUserRole
MINIMUM PERMISSIONS FOR VERSION 6.x and 7.x:
- Must be assigned the db_owner role on the Change Auditor database
- Must be assigned the SQL Server role of db_creator
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.