Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> auditing actions

auditing actions

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Mon, 16 Apr 2007 12:57:33 -0500
Message-ID: <BAY133-F192F2F219D0B4A2E86067197520@phx.gbl>


Can you join aud$ and audit_actions to pull useful information?

select count(*), a.action#, aa.name, a.obj$name from sys.aud$ a, audit_actions aa
where a.action# = aa.action
group by a.action#, aa.name, a.obj$name
/

Is this the correct join for sys.aud$?

Is this what most people do to pull then number of actions (i.e. select , update, ..)
from the aud$ table with name value and object (obj$name)?

thanks.



Canít afford to quit your job? Ė Earn your AS, BS, or MS degree online in 1 year.
http://www.classesusa.com/clickcount.cfm?id=866145&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D866143
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 16 2007 - 12:57:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US