Re: auditing actions
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: joe_dba@xxxxxxxxxxx
- Date: Tue, 17 Apr 2007 22:41:16 +0200
Check out the definition of the dba_audit_trail view. That'll show you how
to query those base tables
Stefan
On 4/16/07, Joe Smith <joe_dba@xxxxxxxxxxx> wrote:
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
--
//www.freelists.org/webpage/oracle-l
--
=========================
Stefan P Knecht
Consultant
Infrastructure Managed Services
Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg
Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht@xxxxxxxxxxxx
http://www.trivadis.com
=========================
Other related posts:
