You can adjust the amount of information that is logged by adjusting the audit level for each table. You can refine the audit further by setting the audit level individually for insert, updates, and deletes within each table.
Auditing Levels
Level | Description |
|---|---|
Level 0 | No audit. |
Level 1 | Row-level audit. Audit only the operation without column details |
Level 2 | Column-level Audit without blobs. Audit changes to the data at the column level but without blob changes |
Level 3 | Full Audit. Audit changes to the data at the column level. For Microsoft SQL server, column level changes to blobs are not included. |