ALL_AUDIT_POLICIES

ALL_AUDIT_POLICIES describes the fine-grained auditing policies on the tables and views accessible to the current user.

Related Views

DBA_AUDIT_POLICIES describes all fine-grained auditing policies in the database.
USER_AUDIT_POLICIES describes the fine-grained auditing policies on the tables and views owned by the current user. This view does not display the OBJECT_SCHEMA column.

Column	Datatype	Description
`OBJECT_SCHEMA`	`VARCHAR2(30)`	Owner of the table or view
`OBJECT_NAME`	`VARCHAR2(30)`	Name of the table or view
`POLICY_OWNER`	`VARCHAR2(30)`	Owner of the policy
`POLICY_NAME`	`VARCHAR2(30)`	Name of the policy
`POLICY_TEXT`	`VARCHAR2(4000)`	Audit condition
`POLICY_COLUMN`	`VARCHAR2(30)`	Relevant column
`PF_SCHEMA`	`VARCHAR2(30)`	Owner of the audit handler function
`PF_PACKAGE`	`VARCHAR2(30)`	Name of the package containing the audit handler function
`PF_FUNCTION`	`VARCHAR2(30)`	Name of the audit handler function
`ENABLED`	`VARCHAR2(3)`	Indicates whether the policy is enabled (`YES`) or disabled (`NO`)
`SEL`	`VARCHAR2(3)`	Indicates whether the policy is applied to queries on the object (`YES`) or not (`NO`)
`INS`	`VARCHAR2(3)`	Indicates whether the policy is applied to `INSERT` statements on the object (`YES`) or not (`NO`)
`UPD`	`VARCHAR2(3)`	Indicates whether the policy is applied to `UPDATE` statements on the object (`YES`) or not (`NO`)
`DEL`	`VARCHAR2(3)`	Indicates whether the policy is applied to `DELETE` statements on the object (`YES`) or not (`NO`)
`AUDIT_TRAIL`	`VARCHAR2(12)`	Indicates the audit trail to which the audit records generated by this audit policy will be written: `DB` - Audit records are written to `DBA_FGA_AUDIT_TRAIL` (fine-grained audit trail) `DB+EXTENDED` - Audit records are written to `DBA_FGA_AUDIT_TRAIL` (fine-grained audit trail) and the `SQL_TEXT` and `SQL_BIND` columns are populated for this policy `XML` - Audit records are written to `V$XML_AUDIT_TRAIL` (XML audit files) `XML+EXTENDED` - Audit records are written to `V$XML_AUDIT_TRAIL` (XML audit files) and the `SQL_TEXT` and `SQL_BIND` columns are populated for this policy
`POLICY_COLUMN_OPTIONS`	`VARCHAR2(11)`	Indicates whether all columns in the `AUDIT_COLUMN` parameter (`ALL_COLUMNS`) or any of the columns in the `AUDIT_COLUMN` parameter (`ANY_COLUMNS`) are considered for triggering fine-grained auditing