2.61 ALL_AUDIT_POLICY_COLUMNS

ALL_AUDIT_POLICY_COLUMNS describes the fine-grained auditing policy columns 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_POLICY_COLUMNS describes all fine-grained auditing policy columns in the database.

  • USER_AUDIT_POLICY_COLUMNS describes the fine-grained auditing policy columns on the tables and views owned by the current user.

Column Datatype NULL Description

OBJECT_SCHEMA

VARCHAR2(128)

Owner of the table or view

OBJECT_NAME

VARCHAR2(128)

Name of the table or view

POLICY_NAME

VARCHAR2(128)

Name of the policy

POLICY_COLUMN

VARCHAR2(128)

Relevant column of the policy