Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This window 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 CM SQL Compliance Manager for the first time.

Available fields

...

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.

 

Excerpt
SQL Compliance Manager audits all activity on your server. Learn more > >