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

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

Re: auditing actions

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Tue, 17 Apr 2007 22:41:16 +0200
Message-ID: <486b2b610704171341pec006b0w844d5510f5fb7dee@mail.gmail.com>


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_at_hotmail.com> 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
>
> --
> http://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_at_trivadis.com
http://www.trivadis.com

=========================

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 17 2007 - 15:41:16 CDT

Original text of this message

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