ALL_AUDIT_POLICIES
describes the fine-grained auditing policies on the tables and views accessible to the current user.
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) |
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 |
See Also: