RE: Auditing query

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 24 Feb 2010 09:54:49 -0500

select * from dba_stmt_audit_opts


select * from dba_priv_audit_opts


Should return:


USER_NAME                      PROXY_NAME
------------------------------ ------------------------------
AUDIT_OPTION                             SUCCESS    FAILURE
---------------------------------------- ---------- ----------


CREATE SESSION                           NOT SET    BY ACCESS


Dick Goulet 
Senior Oracle DBA/NA Team Lead 
PAREXEL International 



From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: Wednesday, February 24, 2010 9:27 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Auditing query

For an auditor, I am in a rush to show that auditing of create session
has been set up for every user in the database.   What is the best query
to do this without showing too much other information?   There are quite
a few tables relating to auditing in 10g.


Hotmail: Trusted email with Microsoft's powerful SPAM protection. Sign
up now. <>  

Other related posts: