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

VIEW: SYS.CDB_AUDIT_POLICIES

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

Fine grained auditing policies in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_SCHEMA VARCHAR2 (30) Yes Owner of the table or view
OBJECT_NAME VARCHAR2 (30) Yes Name of the table or view
POLICY_OWNER VARCHAR2 (30) Yes Owner of the policy
POLICY_NAME VARCHAR2 (128) Yes 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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_AUDIT_POLICIES;

Dependencies

[top of page]

SYS.CDB_AUDIT_POLICIES does not reference any database object

SYS.CDB_AUDIT_POLICIES is referenced by following:

SchemaPUBLIC
SynonymCDB_AUDIT_POLICIES