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	NULL	Description
  OBJECT_SCHEMA	VARCHAR2(30)		Owner of the table or view
  OBJECT_NAME	VARCHAR2(30)		Name of the table or view
  POLICY_NAME	VARCHAR2(30)		Name of the policy
  POLICY_TEXT	VARCHAR2(30)		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)

  See Also: "DBA_AUDIT_POLICIES" "USER_AUDIT_POLICIES"