Page History

The DML and SELECT Audit Filters
This window of the Configuration window allows you to specify which database objects you want to audit for DML and SELECT statements in IDERA SQL Compliance Manager. These settings are available when you choose to audit DML or SELECT statements on the selected databases, and you are using the Custom audit collection level. You can audit all database objects or specific database objects, such as user tables and stored procedures.

For example, if you chose to audit SELECT statements on user tables, the Collection Server retrieves SQL Server events that comprise of SELECT operations run on user tables in the audited database.

Select the database objects you want to audit, and then click Next.