Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
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
View PDF

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) NOT NULL Owner of the table or view
OBJECT_NAME VARCHAR2(30) NOT NULL Name of the table or view
POLICY_NAME VARCHAR2(30) NOT NULL 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(11)   Indicates whether the SQL_TEXT and SQL_BIND columns in the fine-grained audit trail are populated for this policy (DB_EXTENDED) or not (DB)
POLICY_COLUMN_OPTION 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