Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_AUDIT_POLICIES

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

Related Views

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_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