IDERA SQL Compliance Manager 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

Idera Default Database 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:

• • Security changes
  • Database Modification (DML)
  • Access Check Filter - setting selected at server level. 

Before-After Data

These settings must be set on the individual database level. 

Sensitive Columns tab

These settings must be set on the individual database level. 

Trusted Users tab

No users selected

Privileged Users Auditing tab

No users selected