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 |
