Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        Oracle Security >> Oracle Security >> Who is being Audited
        
(Message started by: Pete Finnigan on Nov 16^th, 2005, 4:08pm)

Title: Who is being Audited
Post by Pete Finnigan on Nov 16^th, 2005, 4:08pm

I am using the command "audit all by fred;" to turn on auditing for that user.

Is there a query that I can run to see which users have been enabled for auditing?

There are a number of views starting with DBA_AUDIT% but I can't find one that contains the info I need.

Thanks,
Alan...

Title: Re: Who is being Audited
Post by Pete Finnigan on Nov 16^th, 2005, 4:59pm

Alan,

Try dba_stmt_audit_opts. I'm not sure that's the view you are looking for but I think it is.
See: http://www.ss64.com/orad/DBA_STMT_AUDIT_OPTS.html
Ivan