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