The Sensitive Column window of the Configuration wizard allows you to select the table columns you want IDERA SQL Compliance Manager to audit for sensitive column access using SELECT events. This information is important to track whether a third-party application or database user read data in a specific table column.
Enable this feature on a database to review the SELECT events in the Audit Events view. Note that this feature can affect the performance of your Collection Server and Management Console. You can audit sensitive columns on specific tables without enabling SELECT statement auditing at the database level.
Sensitive column auditing is not available until you deploy an agent to audit the server and a heartbeat is received.
Sensitive Column auditing is supported by SQL Compliance Manager Agent 3.5 or later. To use this feature, please ensure you upgrade your agent to at least version 3.5.
Available actions
Add
Allows you to select one or more database tables to audit for sensitive columns.
Remove
Allows you to remove the selected database table from the list of audited tables.
AddDataSet
Allows you to specify a group of columns to audit as a set of sensitive information.