Configuring an Oracle Text DR$ Index Tables Audit Policy

You can use the ACTIONS clause in the CREATE AUDIT POLICY statement to create a unified audit policy on Oracle Text DR$ index tables.

• Use the following syntax to create a unified audit policy for a table that has an Oracle Text DR$ index table:

CREATE AUDIT POLICY policy_name
ACTIONS action ON schema.table, action ON schema.DR$index_table;

For example, to audit the main index table (using the $I keyword) for a table (sales) that has an index named sales_idx:

CREATE AUDIT POLICY sales_pol
ACTIONS ALL ON sales, ALL ON DR$sales_idx$I;