RE: Auditing query

From: Goulet, Richard <>
Date: Wed, 24 Feb 2010 09:54:49 -0500
Message-ID: <>

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  

[] On Behalf Of J. Dex Sent: Wednesday, February 24, 2010 9:27 AM To:
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. <>

Received on Wed Feb 24 2010 - 08:54:49 CST

Original text of this message