Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Sensitive Columns

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

...

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.

Specify which columns to audit

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

Available fields

Table Name

Provides the name of the table you are auditing on this database.

Columns

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 being audited for SELECT events.

Set up auditing sensitive columns

Sensitive column auditing occurs independently from your other database-level audit settings.

  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.

 

SQL Compliance Manager audits all activity on your server. Learn more > >