DBA_XS_AUDIT

6.154 DBA_XS_AUDIT_TRAIL

DBA_XS_AUDIT_TRAIL describes all audit records specific to Oracle Database Real Application Security.

Column	Datatype	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