Page History
This window The Server Audit Settings window of the Configuration wizard allows you to specify which types of SQL Server events you want to audit on the selected instance. IDERA SQL Compliance Manager audits these events at the server level only.
...
Allows you select the type of activity you want to audit. Based on your selections, SQL CM Compliance Manager collects and processes the corresponding SQL Server events. You can choose to audit event categories and user defined events. An event category includes related SQL Server events that occur at the server level. A user defined event is a custom event you create and track using the sp_trace_generateevent stored procedure.
...
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 registered instance , SQL CM Compliance Manager collects access check events at the server level.
...
| 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 |
...
| Excerpt |
|---|
SQL Compliance Manager audits all activity on your server. Learn more > > |