Page History

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:

...

• Default Database Permissions
  • Grant right to read events and their associated SQL statements
• SQL Statement Limit
  
  • Truncate stored SQL statements after 512 characters

Image Modified

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:

...

No users selected