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.

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 NULL 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)