You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

DML/SELECT Filters

 This tab 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.

TIP

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.

  • No labels