DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_AUDIT_POLICIES

Object Details
Object Name: ALL_AUDIT_POLICIES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All fine grained auditing policies in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_SCHEMA VARCHAR2 (128)
Owner of the table or view
OBJECT_NAME VARCHAR2 (128)
Name of the table or view
POLICY_OWNER VARCHAR2 (128)
Owner of the policy
POLICY_NAME VARCHAR2 (128)
Name of the policy
POLICY_TEXT VARCHAR2 (4000)
Audit condition
POLICY_COLUMN VARCHAR2 (128)
Deprecated
PF_SCHEMA VARCHAR2 (128)
Owner of the audit handler function
PF_PACKAGE VARCHAR2 (128)
Name of the package containing the audit handler function
PF_FUNCTION VARCHAR2 (128)
Name of the audit handler function
ENABLED VARCHAR2 (3)
Is this policy is enabled?
SEL VARCHAR2 (3)
If YES, policy is applied to query on the object
INS VARCHAR2 (3)
If YES, policy is applied to insert on the object
UPD VARCHAR2 (3)
If YES, policy is applied to update on the object
DEL VARCHAR2 (3)
If YES, policy is applied to delete on the object
AUDIT_TRAIL VARCHAR2 (12)
Whether to populate SQLTEXT and SQLBIND columns in audit trail for this policy. DB_EXTENDED -> Populate; DB -> Do not populate
POLICY_COLUMN_OPTIONS VARCHAR2 (11)
If ALL_COLUMNS then all relevant columns apply else any of the relevant columns apply
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJECT_SCHEMA
,      OBJECT_NAME
,      POLICY_OWNER
,      POLICY_NAME
,      POLICY_TEXT
,      POLICY_COLUMN
,      PF_SCHEMA
,      PF_PACKAGE
,      PF_FUNCTION
,      ENABLED
,      SEL
,      INS
,      UPD
,      DEL
,      AUDIT_TRAIL
,      POLICY_COLUMN_OPTIONS
FROM SYS.ALL_AUDIT_POLICIES;

Dependencies

[top of page]

SYS.ALL_AUDIT_POLICIES references the following:

SchemaSYS
ViewALL_TABLES
ViewALL_VIEWS
ViewDBA_AUDIT_POLICIES
FunctionGETLONG
SYS.ALL_AUDIT_POLICIES is referenced by following:

SchemaPUBLIC
SynonymALL_AUDIT_POLICIES