![]() ![]() ![]() (from_tz(ntimestamp#,'00:00') at local) as date),ġ08 /* grant sys_privesubstr(auth$privileges,1,1),ġ09 /* revoke sys_priv */, substr(auth$privileges,1,1),ġ14 /* grant role */, substr(auth$privileges,1,1),ġ15 /* revoke role */, substr(auth$privileges,1,1),Ĭast((from_tz(cast(logoff$time as timestamp),'00:00') at local) as date) From sqlcli SQL> ddl aud$ĬREATE OR REPLACE FORCE VIEW "SYS"."DBA_AUDIT_TRAIL" ("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") AS AUD$ is the base table where as DBA_AUDIT_TRAIL is VIEW.
0 Comments
Leave a Reply. |