Page History
The Audited Activities tab of the Audited Database Properties tab allows you to change which types of SQL Server events you want to audit on the selected databases. Use the Audit Events tab to see your collected data.
Available fields
Audited Activities
Allows you to select the type of activity you want to audit. Based on your selections, IDERA SQL Compliance Manager collects and processes the corresponding SQL Server events.
The following are the activities you can audit:
- Security changes
- Administrative Actions
- Database Definition (DDL)
- Database Modification (DML)
- Database SELECT operations
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.
...
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 |
Capture SQL statements for DML and SELECT activity
...