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

VIEW: SYS.CDB_XS_AUDIT_TRAIL

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

Describes all XS related audit records in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
USERID VARCHAR2 (30)
Name of the user whose actions were audited
ACTION NUMBER

Numeric audit trail action type code
ACTION_NAME VARCHAR2 (64)
Name of the audit option
OBJ_OWNER VARCHAR2 (30)
Owner of the object affected by the action
OBJ_NAME VARCHAR2 (128)
Name of the object affected by the action
RETURN_CODE NUMBER

Oracle error code generated by the action
XS_USER_NAME VARCHAR2 (128)
Name of the XS user
XS_SESSIONID RAW (33)
Identifer of the XS session
XS_INACTIVITY_TIMEOUT NUMBER

Inactivity timeout of the XS session
XS_ENTITY_TYPE VARCHAR2 (32)
Type of the XS entity. Possible values are USER,ROLE, ROLESET, SECURITYCLASS, ACL, DATASECURITY and NSTEMPLATE
XS_TARGET_PRINCIPAL_NAME VARCHAR2 (30)
Target principal name in XS operations. Possible operations are set verifier, set password, add proxy, remove proxy, switch user, assign user, create session, grant roles
XS_PROXY_USER_NAME VARCHAR2 (30)
Name of the XS proxy user
XS_DATASEC_POLICY_NAME VARCHAR2 (30)
Name of the XS data security policy enabled or disabled
XS_SCHEMA_NAME VARCHAR2 (30)
Name of the schema in enable, disable data security and global callback operation
XS_CALLBACK_EVENT_TYPE VARCHAR2 (32)
XS global callback event type
XS_PACKAGE_NAME VARCHAR2 (30)
XS callback package name for the global callback
XS_PROCEDURE_NAME VARCHAR2 (30)
XS callback procedure name for the global callback
XS_ENABLED_ROLE VARCHAR2 (30)
The role that is enabled
XS_COOKIE VARCHAR2 (1024)
XS session cookie
XS_NS_NAME VARCHAR2 (30)
Name of XS session namespace
XS_NS_ATTRIBUTE VARCHAR2 (4000)
Name of XS session namespace attribute
XS_NS_ATTRIBUTE_OLD_VAL VARCHAR2 (4000)
The old value of XS session namespace attribute
XS_NS_ATTRIBUTE_NEW_VAL VARCHAR2 (4000)
The new value of XS session namespace attribute
EVENT_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE (20)
Timestamp of audit record
CON_ID NUMBER

container id
Query Text

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


SELECT USERID
,      ACTION
,      ACTION_NAME
,      OBJ_OWNER
,      OBJ_NAME
,      RETURN_CODE
,      XS_USER_NAME
,      XS_SESSIONID
,      XS_INACTIVITY_TIMEOUT
,      XS_ENTITY_TYPE
,      XS_TARGET_PRINCIPAL_NAME
,      XS_PROXY_USER_NAME
,      XS_DATASEC_POLICY_NAME
,      XS_SCHEMA_NAME
,      XS_CALLBACK_EVENT_TYPE
,      XS_PACKAGE_NAME
,      XS_PROCEDURE_NAME
,      XS_ENABLED_ROLE
,      XS_COOKIE
,      XS_NS_NAME
,      XS_NS_ATTRIBUTE
,      XS_NS_ATTRIBUTE_OLD_VAL
,      XS_NS_ATTRIBUTE_NEW_VAL
,      EVENT_TIMESTAMP
,      CON_ID
FROM SYS.CDB_XS_AUDIT_TRAIL;

Dependencies

[top of page]

SYS.CDB_XS_AUDIT_TRAIL does not reference any database object

SYS.CDB_XS_AUDIT_TRAIL is referenced by following:

SchemaPUBLIC
SynonymCDB_XS_AUDIT_TRAIL