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.