Page History
Database Audit Settings
This window allows you to specify which types of SQL Server events you want to audit on the selected databases in SQL Compliance Manager. This window is available when you choose the Custom audit collection level.
Available fields
Audited Activity
Allows you select the type of activity you want to audit. Based on your selections, SQL CM collects and processes the corresponding SQL Server events.
Access Check Filter
Allows you to refine your audit trail for SQL Server login data by collecting events that better reflect your auditing requirements for security and user processes.
SQL Server validates login permissions and access rights when a user attempts to execute an operation or SQL statement on the audited SQL Server instance. If the access check filter is enabled for a database on a registered instance, SQL CM collects access check events at the database level.
Select this filter to help identify logins that may have inappropriate access rights or permissions. This filter may also help reduce the size of your audit data.
Type of Event Filter | Description |
|---|---|
Audit only actions that passed access check | Omits events that track failed access checks performed by SQL Server |
Audit only actions that failed access check | Omits events that track passed access checks performed by SQL Server |
...