Example: Auditing Update Actions on an Oracle Text DR$ Index Table

The CREATE AUDIT POLICY statement can audit all or specific actions on an Oracle Text DR$ index table. Example 2-8 shows how to create and enable a unified audit policy for the emp_data table that captures user update attempts on this table’s Oracle Text index table, DR$emp_data_idx$I.

Example 2-8 Auditing Update Actions on an Oracle Text DR$ Index Table

CREATE AUDIT POLICY emp_data_pol ACTIONS UPDATE ON emp_data,
UPDATE ON DR$emp_data_idx$I;

AUDIT POLICY emp_data_pol;