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

VIEW: SYS.AUDIT_UNIFIED_POLICIES

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

Describes the Audit policy's definition of all policies created in database

[View Source]

Columns
Name Datatype Length Mandatory Comments
POLICY_NAME VARCHAR2 (128)
Name of the Audit policy
AUDIT_CONDITION VARCHAR2 (4000)
Condition associated with the Audit policy
CONDITION_EVAL_OPT VARCHAR2 (9)
Evaluation option associated with the Audit policy's Condition. The possible values are STATEMENT, SESSION, INSTANCE, NONE.
AUDIT_OPTION VARCHAR2 (128)
Auditing option defined in the Audit policy
AUDIT_OPTION_TYPE VARCHAR2 (18)
Type of the Auditing option. The possible values are SYSTEM PRIVILEGE, SYSTEM ACTION, OBJECT ACTION, INVALID
OBJECT_SCHEMA VARCHAR2 (128)
Owner of the object, in case of Object-specific auditing option
OBJECT_NAME VARCHAR2 (128)
Name of the object, in case of Object-specific auditing option
OBJECT_TYPE VARCHAR2 (23)
Type of the object, in case of Object-specific auditing option
COMMON VARCHAR2 (3)
Whether the audit policy is a Common Audit Policy or Local. It is NULL in case of nonconsolidated databases
Query Text

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


SELECT POLICY_NAME
,      AUDIT_CONDITION
,      CONDITION_EVAL_OPT
,      AUDIT_OPTION
,      AUDIT_OPTION_TYPE
,      OBJECT_SCHEMA
,      OBJECT_NAME
,      OBJECT_TYPE
,      COMMON
FROM SYS.AUDIT_UNIFIED_POLICIES;

Dependencies

[top of page]

SYS.AUDIT_UNIFIED_POLICIES references the following:

SchemaSYS
ViewAUDITABLE_OBJECT_ACTIONS
ViewAUDITABLE_SYSTEM_ACTIONS
TableAUD_OBJECT_OPT$
TableAUD_POLICY$
ViewDBA_OBJECTS
TableOBJ$
TableSYSTEM_PRIVILEGE_MAP
TableUSER$
SYS.AUDIT_UNIFIED_POLICIES is referenced by following:

SchemaPUBLIC
SynonymAUDIT_UNIFIED_POLICIES
SchemaSYS
ViewDBA_XS_AUDIT_POLICY_OPTIONS
ViewDBA_XS_ENB_AUDIT_POLICIES
ProcedureDBMS_FEATURE_UNIFIED_AUDIT - show dependent code