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(30)

 

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(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 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(30)

 

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(30)

 

Name of the Real Application Security proxy user.

XS_DATASEC_POLICY_NAME

VARCHAR2(30)

 

Name of the Real Application Security data security policy enabled or disabled

XS_SCHEMA_NAME

VARCHAR2(30)

 

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(30)

 

Real Application Security callback package name for the global callback

XS_PROCEDURE_NAME

VARCHAR2(30)

 

Real Application Security callback procedure name for the global callback

XS_ENABLED_ROLE

VARCHAR2(30)

 

The role that is enabled

XS_COOKIE

VARCHAR2(1024)

 

Real Application Security session cookie

XS_NS_NAME

VARCHAR2(30)

 

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 Database Security Guide for more information about auditing