VIEW: SYS.CDB_AUDIT_TRAIL

Source

View Text - Preformatted

SELECT "OS_USERNAME","USERNAME","USERHOST","TERMINAL","TIMESTAMP","OWNER","OBJ_NAME","ACTION","ACTION_NAME","NEW_OWNER","NEW_NAME","OBJ_PRIVILEGE","SYS_PRIVILEGE","ADMIN_OPTION","GRANTEE","AUDIT_OPTION","SES_ACTIONS","LOGOFF_TIME","LOGOFF_LREAD","LOGOFF_PREAD","LOGOFF_LWRITE","LOGOFF_DLOCK","COMMENT_TEXT","SESSIONID","ENTRYID","STATEMENTID","RETURNCODE","PRIV_USED","CLIENT_ID","ECONTEXT_ID","SESSION_CPU","EXTENDED_TIMESTAMP","PROXY_SESSIONID","GLOBAL_UID","INSTANCE_NUMBER","OS_PROCESS","TRANSACTIONID","SCN","SQL_BIND","SQL_TEXT","OBJ_EDITION_NAME","DBID","CON_ID" FROM CONTAINERS("SYS"."DBA_AUDIT_TRAIL")

View Text - HTML Formatted

SELECT "OS_USERNAME"
, "USERNAME"
, "USERHOST"
, "TERMINAL"
, "TIMESTAMP"
, "OWNER"
, "OBJ_NAME"
, "ACTION"
, "ACTION_NAME"
, "NEW_OWNER"
, "NEW_NAME"
, "OBJ_PRIVILEGE"
, "SYS_PRIVILEGE"
, "ADMIN_OPTION"
, "GRANTEE"
, "AUDIT_OPTION"
, "SES_ACTIONS"
, "LOGOFF_TIME"
, "LOGOFF_LREAD"
, "LOGOFF_PREAD"
, "LOGOFF_LWRITE"
, "LOGOFF_DLOCK"
, "COMMENT_TEXT"
, "SESSIONID"
, "ENTRYID"
, "STATEMENTID"
, "RETURNCODE"
, "PRIV_USED"
, "CLIENT_ID"
, "ECONTEXT_ID"
, "SESSION_CPU"
, "EXTENDED_TIMESTAMP"
, "PROXY_SESSIONID"
, "GLOBAL_UID"
, "INSTANCE_NUMBER"
, "OS_PROCESS"
, "TRANSACTIONID"
, "SCN"
, "SQL_BIND"
, "SQL_TEXT"
, "OBJ_EDITION_NAME"
, "DBID"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_AUDIT_TRAIL")