RE: Auditing query

select * from dba_stmt_audit_opts

union

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. <http://clk.atdmt.com/GBL/go/201469226/direct/01/>  

Other related posts: