GV$XML_AUDIT_TRAIL

select
INST_ID,                 -- INST_ID NUMBER
AUDIT_TYPE,              -- AUDIT_TYPE NUMBER
SESSION_ID,              -- SESSION_ID NUMBER
PROXY_SESSIONID,         -- PROXY_SESSIONID NUMBER
STATEMENTID,             -- STATEMENTID NUMBER
ENTRYID,                 -- ENTRYID NUMBER
EXTENDED_TIMESTAMP,      -- EXTENDED_TIMESTAMP TIMESTAMP(6)
GLOBAL_UID,              -- GLOBAL_UID VARCHAR2(32)
DB_USER,                 -- DB_USER VARCHAR2(30)
CLIENTIDENTIFIER,        -- CLIENTIDENTIFIER VARCHAR2(64)
EXT_NAME,                -- EXT_NAME VARCHAR2(1024)
OS_USER,                 -- OS_USER VARCHAR2(30)
OS_HOST,                 -- OS_HOST VARCHAR2(128)
OS_PROCESS,              -- OS_PROCESS VARCHAR2(16)
TERMINAL,                -- TERMINAL VARCHAR2(30)
INSTANCE_NUMBER,         -- INSTANCE_NUMBER NUMBER
OBJECT_SCHEMA,           -- OBJECT_SCHEMA VARCHAR2(30)
OBJECT_NAME,             -- OBJECT_NAME VARCHAR2(30)
POLICY_NAME,             -- POLICY_NAME VARCHAR2(30)
NEW_OWNER,               -- NEW_OWNER VARCHAR2(30)
NEW_NAME,                -- NEW_NAME VARCHAR2(30)
ACTION,                  -- ACTION NUMBER
STATEMENT_TYPE,          -- STATEMENT_TYPE NUMBER
TRANSACTIONID,           -- TRANSACTIONID RAW(8)
RETURNCODE,              -- RETURNCODE NUMBER
SCN,                     -- SCN NUMBER
COMMENT_TEXT,            -- COMMENT_TEXT VARCHAR2(4000)
AUTH_PRIVILEGES,         -- AUTH_PRIVILEGES VARCHAR2(16)
GRANTEE,                 -- GRANTEE VARCHAR2(30)
PRIV_USED,               -- PRIV_USED NUMBER
SES_ACTIONS,             -- SES_ACTIONS VARCHAR2(16)
OS_PRIVILEGE,            -- OS_PRIVILEGE VARCHAR2(7)
ECONTEXT_ID,             -- ECONTEXT_ID VARCHAR2(64)
SQL_BIND,                -- SQL_BIND VARCHAR2(4000)
SQL_TEXT                 -- SQL_TEXT VARCHAR2(4000)
from
X$XML_AUDIT_TRAIL
home |  up  |  mailbox