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
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: