You can use two configuration procedures to provide simple control of the auditing feature:
- auditing_enable(table_name, level)
- auditing_disable(table_name)
You can set the audit level on an individual table or the same audit level for all of the tables. However, the simple configuration procedures do not allow for setting individual auditing levels for insert, update, or delete operations within a table.
Examples for Oracle
Use the following examples as a guide to use the simple audit configuration procedures to control the auditing feature.
- The following code snippet enables full auditing on all tables:
exec auditing_enable(null,3);
- The following code snippet enables level one auditing on the task table:
exec auditing_enable('TASK',1);
- The following code snippet disables auditing on PROJWBS:
exec auditing_disable('PROJWBS');
- The following code snippet completely disables auditing across the entire database:
exec auditing_disable(null);