The DML/Select Filters tab of the Audited Database Properties window allows you to change which database objects you want to audit for DML and SELECT statements. These settings are available when you choose to audit DML or SELECT statements on the selected databases. 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.
To successfully audit before and after data, ensure you select the target user tables.
Available actions
Add
Allows you to enable auditing of DML and SELECT events on one or more user tables.
Remove
Allows you to remove the selected user table from the list of audited user tables. When you remove the user table, the SQLcompliance Agent will no longer collect DML and SELECT events recorded for that user table.