KB-9124: What are the default permissions granted to a setup user for Direct Audit?

Home >

KB-9124: What are the default permissions granted to a setup user for Direct Audit?

Product:

Centrify DirectAudit ,

Published:

27 September,17 at 07:41 PM

Rating:

Question:
What are the default permissions and SQL Server roles granted to a setup user for Centrify Management Services - Audit & Monitor and how to check them?

Answer:
In Centrify Management Services - Audit & Monitor, the setup user is granted two types of permissions, application permissions and specific SQL server roles.
-The application permissions are visible through the Centrify Audit Manager console. These are listed in Part 1.
-The SQL server roles are viewed by having the Database Administrator (DBA) log onto the SQL Server using SQL Server Management Studio. These are listed in Part 2.

Part 1)
Default Application Permissions granted to the setup user:
Installation Permissions (Right Click Installation Name>Properties>Security)
1)Full Control

Management Database Permissions (Right Click Installation Name>Management Databases…>Select the management database>Properties>Security)
1)Full Control

Audit Store and Audit Store Database Permissions (Expand Audit Stores>Right click AuditStore>Properties>Security)
1)Full Control

Master Auditor - The setup user also becomes the first member of the “Master Auditor” role.

Part 2)
Default SQL Server Roles granted to the setup user (these can be verified by logging into the Direct Audit instance using SQL management studio. :

Management database roles (Expand the Security folder>Logins>Right click on your setup user>Properties>Server Roles>User Mapping>Select Management Database)
1)db_owner
2)public
3)user

Audit Store database roles (Expand the Security folder>Logins>Right click on your setup user>Properties>Server Roles>User Mapping>Select Audit Store Database)
1)public
2)setup_user

Note: As a prerequisite the setup user must have sysadmin rights to create the databases.