Defining auditing rules

The names of the audited tables and the level of auditing required are defined in the SQLAF RULES dataset.

Some examples of auditing rules:

- Audit select, update, delete and insert activity on all accounting tables:

- TABLE ACCOUNT.%
- AUDIT ALL

- Audit update, delete and insert activity on the customer table:

- TABLE SQLDBA.CUSTOMER
- AUDIT CHANGE

- Audit all SQL statements that retrieve or update the CONFIDENTIAL_INFO column:

- TABLE SQLDBA.EMPLOYEES
- COLUMN CONFIDENTIAL_INFO
- AUDIT ALL