[Home] [Help] [Dependency Information]
Object Name: | DBA_XS_AUDIT_TRAIL |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Describes all XS related audit records
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 |
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
FROM SYS.DBA_XS_AUDIT_TRAIL;
|
|
|