Ensure each IDERA SQL Compliance Manager user has a SQL Server login. When you grant SQL Compliance Manager permissions to a login, SQL Compliance Manager assigns either the System Administrators role or read privileges on the Repository databases. You can quickly and easily grant these permissions using the Management Console.
The System Administrators role allows the user to perform administrative activities in SQL Compliance Manager, such as:
- Registering SQL Server instances
- Enabling or disabling auditing
- Configuring audit settings
Read privileges allow the user to view collected audit data and generate reports on audited events.
You can also set default permissions on the registered SQL Server instance or an individual archive database. For more information about setting your default permissions, see Understanding default permissions.