Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

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

Centrify DirectAudit ,  

27 September,17 at 07:41 PM

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.

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.