VIEW: SYS.USER_AUDIT_TRAIL

Source

View Text - Preformatted

select d."OS_USERNAME",d."USERNAME",d."USERHOST",d."TERMINAL",d."TIMESTAMP",d."OWNER",d."OBJ_NAME",d."ACTION",d."ACTION_NAME",d."NEW_OWNER",d."NEW_NAME",d."OBJ_PRIVILEGE",d."SYS_PRIVILEGE",d."ADMIN_OPTION",d."GRANTEE",d."AUDIT_OPTION",d."SES_ACTIONS",d."LOGOFF_TIME",d."LOGOFF_LREAD",d."LOGOFF_PREAD",d."LOGOFF_LWRITE",d."LOGOFF_DLOCK",d."COMMENT_TEXT",d."SESSIONID",d."ENTRYID",d."STATEMENTID",d."RETURNCODE",d."PRIV_USED",d."CLIENT_ID",d."ECONTEXT_ID",d."SESSION_CPU",d."EXTENDED_TIMESTAMP",d."PROXY_SESSIONID",d."GLOBAL_UID",d."INSTANCE_NUMBER",d."OS_PROCESS",d."TRANSACTIONID",d."SCN",d."SQL_BIND",d."SQL_TEXT",d."OBJ_EDITION_NAME",d."DBID" from dba_audit_trail d, sys.user$ u
where ((d.owner = u.name and u.user# = USERENV('SCHEMAID'))
or (d.owner is null and d.username = u.name and u.user# = USERENV('SCHEMAID')))

View Text - HTML Formatted

SELECT D."OS_USERNAME"
, D."USERNAME"
, D."USERHOST"
, D."TERMINAL"
, D."TIMESTAMP"
, D."OWNER"
, D."OBJ_NAME"
, D."ACTION"
, D."ACTION_NAME"
, D."NEW_OWNER"
, D."NEW_NAME"
, D."OBJ_PRIVILEGE"
, D."SYS_PRIVILEGE"
, D."ADMIN_OPTION"
, D."GRANTEE"
, D."AUDIT_OPTION"
, D."SES_ACTIONS"
, D."LOGOFF_TIME"
, D."LOGOFF_LREAD"
, D."LOGOFF_PREAD"
, D."LOGOFF_LWRITE"
, D."LOGOFF_DLOCK"
, D."COMMENT_TEXT"
, D."SESSIONID"
, D."ENTRYID"
, D."STATEMENTID"
, D."RETURNCODE"
, D."PRIV_USED"
, D."CLIENT_ID"
, D."ECONTEXT_ID"
, D."SESSION_CPU"
, D."EXTENDED_TIMESTAMP"
, D."PROXY_SESSIONID"
, D."GLOBAL_UID"
, D."INSTANCE_NUMBER"
, D."OS_PROCESS"
, D."TRANSACTIONID"
, D."SCN"
, D."SQL_BIND"
, D."SQL_TEXT"
, D."OBJ_EDITION_NAME"
, D."DBID"
FROM DBA_AUDIT_TRAIL D
, SYS.USER$ U WHERE ((D.OWNER = U.NAME
AND U.USER# = USERENV('SCHEMAID')) OR (D.OWNER IS NULL
AND D.USERNAME = U.NAME
AND U.USER# = USERENV('SCHEMAID')))