IDERA SQL Compliance Manager allows users to edit the Server Default Audit Settings in order to comply with their auditing needs.
provides users with a default basic set of settings to begin auditing. These are just the Idera default settings, and users can modify these settings on individual servers and databases to accommodate their auditing needs. These settings will apply to newly added servers and databases. Users can reset back to the Idera default settings at any time by clicking the Reset to Idera Default Settings button.
IDERA Default Server Audit Settings
Audited Activities tab
Allows you to select the type of activity you want to audit. The following are the IDERA Default Database Audit Settings:
- Failed Logins
- Access Check Filter - Filter events based on access check
- Audit only actions that passed access check
- Capture DML and Select Activities
- Via Trace Events
Trusted Users tab
No users selected
Privileged Users Auditing tab
No users selected
Auditing Thresholds tab
No settings enabled
Advanced tab
- Default Database Permissions
- Grant right to read events and their associated SQL statements
- SQL Statement Limit
- Truncate stored SQL statements after 512 characters