Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 
HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Redneck
 

 
   
 

DBA_AUDIT_STATEMENT view tips

Oracle Tips by Burleson Consulting

DBA_AUDIT_STATEMENT

<< Return to the index

Oracle 11g makes the following comments about the DBA_AUDIT_STATEMENT table: "Audit trail records concerning grant, revoke, audit, noaudit and alter system"

Related notes on DBA_AUDIT_STATEMENT:

Column description of the DBA_AUDIT_STATEMENT view:

OS_USERNAME
No comments exist for the OS_USERNAME column of the DBA_AUDIT_STATEMENT table.
USERNAME
No comments exist for the USERNAME column of the DBA_AUDIT_STATEMENT table.
USERHOST
No comments exist for the USERHOST column of the DBA_AUDIT_STATEMENT table.
TERMINAL
No comments exist for the TERMINAL column of the DBA_AUDIT_STATEMENT table.
TIMESTAMP
No comments exist for the TIMESTAMP column of the DBA_AUDIT_STATEMENT table.
OWNER
No comments exist for the OWNER column of the DBA_AUDIT_STATEMENT table.
OBJ_NAME
No comments exist for the OBJ_NAME column of the DBA_AUDIT_STATEMENT table.
ACTION_NAME
No comments exist for the ACTION_NAME column of the DBA_AUDIT_STATEMENT table.
NEW_NAME
No comments exist for the NEW_NAME column of the DBA_AUDIT_STATEMENT table.
OBJ_PRIVILEGE
No comments exist for the OBJ_PRIVILEGE column of the DBA_AUDIT_STATEMENT table.
SYS_PRIVILEGE
No comments exist for the SYS_PRIVILEGE column of the DBA_AUDIT_STATEMENT table.
ADMIN_OPTION
No comments exist for the ADMIN_OPTION column of the DBA_AUDIT_STATEMENT table.
GRANTEE
No comments exist for the GRANTEE column of the DBA_AUDIT_STATEMENT table.
AUDIT_OPTION
No comments exist for the AUDIT_OPTION column of the DBA_AUDIT_STATEMENT table.
SES_ACTIONS
No comments exist for the SES_ACTIONS column of the DBA_AUDIT_STATEMENT table.
COMMENT_TEXT
No comments exist for the COMMENT_TEXT column of the DBA_AUDIT_STATEMENT table.
SESSIONID
No comments exist for the SESSIONID column of the DBA_AUDIT_STATEMENT table.
ENTRYID
No comments exist for the ENTRYID column of the DBA_AUDIT_STATEMENT table.
STATEMENTID
No comments exist for the STATEMENTID column of the DBA_AUDIT_STATEMENT table.
RETURNCODE
No comments exist for the RETURNCODE column of the DBA_AUDIT_STATEMENT table.
PRIV_USED
No comments exist for the PRIV_USED column of the DBA_AUDIT_STATEMENT table.
CLIENT_ID
No comments exist for the CLIENT_ID column of the DBA_AUDIT_STATEMENT table.
ECONTEXT_ID
No comments exist for the ECONTEXT_ID column of the DBA_AUDIT_STATEMENT table.
SESSION_CPU
No comments exist for the SESSION_CPU column of the DBA_AUDIT_STATEMENT table.
EXTENDED_TIMESTAMP
No comments exist for the EXTENDED_TIMESTAMP column of the DBA_AUDIT_STATEMENT table.
PROXY_SESSIONID
No comments exist for the PROXY_SESSIONID column of the DBA_AUDIT_STATEMENT table.
GLOBAL_UID
No comments exist for the GLOBAL_UID column of the DBA_AUDIT_STATEMENT table.
INSTANCE_NUMBER
No comments exist for the INSTANCE_NUMBER column of the DBA_AUDIT_STATEMENT table.
OS_PROCESS
No comments exist for the OS_PROCESS column of the DBA_AUDIT_STATEMENT table.
TRANSACTIONID
No comments exist for the TRANSACTIONID column of the DBA_AUDIT_STATEMENT table.
SCN
No comments exist for the SCN column of the DBA_AUDIT_STATEMENT table.
SQL_BIND
No comments exist for the SQL_BIND column of the DBA_AUDIT_STATEMENT table.
SQL_TEXT
No comments exist for the SQL_TEXT column of the DBA_AUDIT_STATEMENT table.
OBJ_EDITION_NAME
No comments exist for the OBJ_EDITION_NAME column of the DBA_AUDIT_STATEMENT table.

DBA_AUDIT_STATEMENT View Source

Oracle 11g's data dictionary defines the DBA_AUDIT_STATEMENT view using the following source query:

select OS_USERNAME, USERNAME, USERHOST, TERMINAL, TIMESTAMP,
OWNER, OBJ_NAME, ACTION_NAME, NEW_NAME,
OBJ_PRIVILEGE, SYS_PRIVILEGE, ADMIN_OPTION, GRANTEE, AUDIT_OPTION,
SES_ACTIONS, 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
from dba_audit_trail
where action in ( 17 /* GRANT OBJECT */,
18 /* REVOKE OBJECT */,
30 /* AUDIT OBJECT */,
31 /* NOAUDIT OBJECT */,
49 /* ALTER SYSTEM */,
104 /* SYSTEM AUDIT */,
105 /* SYSTEM NOAUDIT */,
106 /* AUDIT DEFAULT */,
107 /* NOAUDIT DEFAULT */,
108 /* SYSTEM GRANT */,
109 /* SYSTEM REVOKE */,
114 /* GRANT ROLE */,
115 /* REVOKE ROLE */ )

 
If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

 

 

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

 
  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book
 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 
   

Copyright © 1996 -  2009 by Burleson Enterprises, Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.