DBA_XS_AUDIT_TRAIL
DBA_XS_AUDIT_TRAIL describes all audit records specific to Oracle Database Real Application Security.
| Column | Datatype | NULL | Description |
|---|---|---|---|
USERID |
VARCHAR2(128) |
Name of the database user whose actions were audited | |
ACTION |
NUMBER |
Numeric audit trail action type code. The corresponding name of the action type is in the ACTION_NAME column. |
|
ACTION_NAME |
VARCHAR2(64) |
Name of the action type corresponding to the numeric code in the ACTION column |
|
OBJ_OWNER |
VARCHAR2(128) |
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 Real Application Security user | |
XS_SESSIONID |
RAW(33) |
Identifer of the Real Application Security session | |
XS_INACTIVITY_TIMEOUT |
NUMBER |
Inactivity timeout of the Real Application Security session | |
XS_ENTITY_TYPE |
VARCHAR2(32) |
Type of the Real Application Security entity. Possible values are USER, ROLE, ROLESET, SECURITYCLASS, ACL, DATASECURITY, and NSTEMPLATE. |
|
XS_TARGET_PRINCIPAL_NAME |
VARCHAR2(128) |
Target principal name in Real Application Security 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(128) |
Name of the Real Application Security proxy user. | |
XS_DATASEC_POLICY_NAME |
VARCHAR2(128) |
Name of the Real Application Security data security policy enabled or disabled | |
XS_SCHEMA_NAME |
VARCHAR2(128) |
Name of the schema in enable, disable data security policy and global callback operation | |
XS_CALLBACK_EVENT_TYPE |
VARCHAR2(32) |
Real Application Security global callback event type | |
XS_PACKAGE_NAME |
VARCHAR2(128) |
Real Application Security callback package name for the global callback | |
XS_PROCEDURE_NAME |
VARCHAR2(128) |
Real Application Security callback procedure name for the global callback | |
XS_ENABLED_ROLE |
VARCHAR2(128) |
The role that is enabled | |
XS_COOKIE |
VARCHAR2(1024) |
Real Application Security session cookie | |
XS_NS_NAME |
VARCHAR2(128) |
Name of the Real Application Security session namespace | |
XS_NS_ATTRIBUTE |
VARCHAR2(4000) |
Name of the Real Application Security session namespace attribute | |
XS_NS_ATTRIBUTE_OLD_VAL |
VARCHAR2(4000) |
The old value of the Real Application Security session namespace attribute | |
XS_NS_ATTRIBUTE_NEW_VAL |
VARCHAR2(4000) |
The new value of the Real Application Security session namespace attribute | |
EVENT_TIMESTAMP |
TIMESTAMP(6) WITH TIME ZONE |
Timestamp of audit record |
See Also: Oracle AI Database Security Guide for more information about auditing