Page History
The Sensitive Columns tab of the Audited Database Properties window allows you allows you to choose select the individual table columns for which you want to audit SELECT eventsor datasets you want IDERA SQL Compliance Manager to audit for sensitive column access. Configure the type of activity you want to collect data for, choose between Selects, Selects and DML or All Activity. This data tells you which third-party application or database user accessed and read the specified columns. You can also create sensitive column data sets, which allows you to monitor sensitive columns as a group of sensitive data. Sensitive Columns can be an individual column or a group of columns that come together to form sensitive data. If no individual columns are selected, by default all columns from the selected table will be audited.
Audit access to sensitive columns when it is critical to capture whether someone read the data in a specific table column. When this feature is enabled, you can review the SELECT events in the Audit Events view. Enabling this feature can impact your Collection Server and Management Console performance. You can audit sensitive columns on specific tables without enabling SELECT statement auditing at the database level.
...
| Info |
|---|
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
Specify tables for before and after data collection
...
Use AddDataSet to specify a group of columns to audit as a set of sensitive information.
Configure
Allows you to choose which type of activity you want Sensitive Columns to collect data for. You can choose one of the following types of activity to collect data for your Sensitive Columns:
- Select Only
- All Activity
- SELECT and DML
Available fields
Table Name
...
- On the Sensitive Columns tab, click Add to choose which audited tables should also be audited at the column level when a user attempts to access this column.
- Choose the appropriate tables, and then click OK. By default, all columns are audited.
- If you want to audit specific columns, select the table, and then click Edit.
- if you want to audit a group of columns, click AddDataSet.
...