VIEW: SYS.DBA_XS_AUDIT_TRAIL

Source

View Text - Preformatted

select audtrail.userid, audtrail.action, xsacts.action_name,
       audtrail.obj_owner, audtrail.obj_name, audtrail.return_code,
       audtrail.xs_user_name, audtrail.xs_sessionid,
       audtrail.xs_inactivity_timeout, audtrail.xs_entity_type,
       audtrail.xs_target_principal_name, audtrail.xs_proxy_user_name,
       audtrail.xs_datasec_policy_name, audtrail.xs_schema_name,
       audtrail.xs_callback_event_type, audtrail.xs_package_name,
       audtrail.xs_procedure_name, audtrail.xs_enabled_role,
       audtrail.xs_cookie, audtrail.xs_ns_name, audtrail.xs_ns_attribute,
       audtrail.xs_ns_attribute_old_val, audtrail.xs_ns_attribute_new_val,
       audtrail.event_timestamp
from sys.v$unified_audit_trail audtrail, sys.x$aud_xs_actions xsacts,
     sys.dba_xs_audit_policy_options xspol
where (xspol.policy_name = 'ORA_RAS_SESSION_MGMT'
      OR xspol.policy_name = 'ORA_RAS_POLICY_MGMT')
      and audtrail.action = xsacts.indx
      and xsacts.action_name = xspol.audit_option
      and audtrail.audit_type = 6
order by event_timestamp

View Text - HTML Formatted

SELECT AUDTRAIL.USERID
, AUDTRAIL.ACTION
, XSACTS.ACTION_NAME
, AUDTRAIL.OBJ_OWNER
, AUDTRAIL.OBJ_NAME
, AUDTRAIL.RETURN_CODE
, AUDTRAIL.XS_USER_NAME
, AUDTRAIL.XS_SESSIONID
, AUDTRAIL.XS_INACTIVITY_TIMEOUT
, AUDTRAIL.XS_ENTITY_TYPE
, AUDTRAIL.XS_TARGET_PRINCIPAL_NAME
, AUDTRAIL.XS_PROXY_USER_NAME
, AUDTRAIL.XS_DATASEC_POLICY_NAME
, AUDTRAIL.XS_SCHEMA_NAME
, AUDTRAIL.XS_CALLBACK_EVENT_TYPE
, AUDTRAIL.XS_PACKAGE_NAME
, AUDTRAIL.XS_PROCEDURE_NAME
, AUDTRAIL.XS_ENABLED_ROLE
, AUDTRAIL.XS_COOKIE
, AUDTRAIL.XS_NS_NAME
, AUDTRAIL.XS_NS_ATTRIBUTE
, AUDTRAIL.XS_NS_ATTRIBUTE_OLD_VAL
, AUDTRAIL.XS_NS_ATTRIBUTE_NEW_VAL
, AUDTRAIL.EVENT_TIMESTAMP FROM SYS.V$UNIFIED_AUDIT_TRAIL AUDTRAIL
, SYS.X$AUD_XS_ACTIONS XSACTS
, SYS.DBA_XS_AUDIT_POLICY_OPTIONS XSPOL WHERE (XSPOL.POLICY_NAME = 'ORA_RAS_SESSION_MGMT' OR XSPOL.POLICY_NAME = 'ORA_RAS_POLICY_MGMT')
AND AUDTRAIL.ACTION = XSACTS.INDX
AND XSACTS.ACTION_NAME = XSPOL.AUDIT_OPTION
AND AUDTRAIL.AUDIT_TYPE = 6 ORDER BY EVENT_TIMESTAMP