The Default Permissions window of the Configuration wizard lets you specify the default permission settings on the Repository databases that contain audit data for this SQL Server instance in IDERA SQL Compliance Manager. Keep in mind that login permissions specified at the database take precedence over the default permissions set on this page. This window is available only when you are registering a SQL Server instance with SQL Compliance Manager for the first time.
Available fields
Grant right to read events and their associated SQL statements
Grant users the right to read events and their associated SQL statements on the database containing audit data for this SQL Server instance.
Grant right to read events only
Grant users the right to read events only. Users cannot read the associated SQL statements when you select this option. To allow users to view the associated SQL statements, you can explicitly grant users read access to the database containing audit data for this SQL Server instance.
Deny read access by default
Deny users the right to read events or their associated SQL statements by default. To allow users to view events and the associated SQL statements, you can explicitly grant users read access to the database containing audit data for this SQL Server instance.