ALL_AUDIT_POLICIES

2.61 ALL_AUDIT_POLICIES

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

Note:

This view is populated only in an Oracle Database where unified auditing is not enabled. When unified auditing is enabled in Oracle Database, the audit records are populated in the new audit trail and can be viewed from UNIFIED_AUDIT_TRAIL.

See Oracle Database Security Guide for more information about unified auditing.
See Oracle Database Upgrade Guide for more information about migrating to unified auditing.

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(128)`	Name of the schema that includes the table or view
`OBJECT_NAME`	`VARCHAR2(128)`	Name of the table or view
`POLICY_OWNER`	`VARCHAR2(128)`	Owner of the policy
`POLICY_NAME`	`VARCHAR2(128)`	Name of the policy
`POLICY_TEXT`	`VARCHAR2(4000)`	Audit condition
`POLICY_COLUMN`	`VARCHAR2(128)`	Relevant column
`PF_SCHEMA`	`VARCHAR2(128)`	Owner of the audit handler function
`PF_PACKAGE`	`VARCHAR2(128)`	Name of the package containing the audit handler function
`PF_FUNCTION`	`VARCHAR2(128)`	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
`COMMON`	`VARCHAR2(3)`	Indicates whether the policy applies across multiple containers (`YES`) or not (`NO`)
`INHERITED`	`VARCHAR2(3)`	Indicates whether the policy was inherited from another container (`YES`) or not (`NO`)