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. With Oracle, column level changes to blobs are audited. With 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. | |