Page History

The Sensitive Columns tab of the Audited Database Properties window allows you to choose the table columns for which you want to audit SELECT events. 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. 

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.

...

...

Specify tables for before and after data collection

Use Add and Remove to specify the tables for which you want to access to specific sensitive columns.

...

Use Edit to specify which columns you want to audit. You can audit all columns or individual columns.

Specify which columns to audit as a group

Use AddDataSet to specify a group of columns to audit as a set of sensitive information. 

Available fields

Table Name

...

Indicates the status of the columns associated with the audited tables. Typically, this field will display All Columns or list the individual columns that are audited for SELECT events.

Type

Indicates whether the column is being audited as an 'Individual' or as part of a 'Dataset'. 

Set up auditing sensitive columns

...

1. 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.
2. Choose the appropriate tables, and then click OK. By default, all columns are audited.
3. If you want to audit specific columns, select the table, and then click Edit.
4. if you want to audit a group of columns, click AddDataSet. 

...

...

...

...

...