Each table's auditing settings are controlled by the Options setting in each table's auditing namespace (for example, database.audit.TASK). The Options setting is a three character string with a numeric value in each character position representing the audit level for insert, update, and delete.
Auditing Level Options Setting by Table Operation | ||||
|---|---|---|---|---|
| Operation |
| ||
| Insert | Update | Delete | Description |
Level
| 0 | 0 | 0 | No audit. |
1 | 1 | 1 | Row-level audit. Audit only the operation without column details. | |
2 | 2 | 2 | Column-level audit without blobs. Audit changes to the data at the column level but without blob changes. | |
3 | 3 | 3 | Full Audit. Audit changes to the data at the column level. For Microsoft SQL server, column level changes to blobs are not included. | |
The following table provides examples of the options setting:
Setting the Auditing Level Options Setting by Table Operation Examples | |||
|---|---|---|---|
Namespace | Setting | Value | Description |
database.audit.TASK |
Options
| 330 | Fully audit any insert and update operations. Do not audit any delete operations. |
database.audit.PROJWBS | 001 | Row-level audit on deletes only. | |
database.audit.TASKRSRC | 333 | Fully audit. | |