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

Home -> Community -> Usenet -> c.d.o.server -> Re: Auditing question

Re: Auditing question

From: <sybrandb_at_yahoo.com>
Date: 9 Dec 2003 06:54:44 -0800
Message-ID: <a1d154f4.0312090654.3d58753c@posting.google.com>


"R.B" <rich.bevan_at_bt.com> wrote in message news:<br4bcv$ref$1_at_visp.bt.co.uk>...
> I have started auditing on a 9.2.0.3 database by setting the following in
> the initSID.ora file
>
> audit_trail = db
> audit_file_dest = /u01/app/oracle/admin/SID/adump
> audit_sys_operations = true
>
> and then setting the database to audit 'create table'. When a table is
> created, an entry is made in a file in the 'audit_file_dest'. What I am
> trying to do is be able to run a query from the db to find the information
> such as - when 'create table' was run and by who etc. Can this information
> be acessed from the db or do scripts have to be written to get the
> information from the Unix files. If I have to get the info from the '.aud'
> files has Oracle already got a utility to do this ?
>
> Thanks for any help

Your combination of parameters is contradictory. Audit_trail = db means the data goes into sys.aud$ and there are many views to make the info more readable like dba_audit_session and dba_audit_trail. As you can store the info in the database, Oracle doesn't have utilities to read the .aud files. In 9i you could of course use the external table feature.

Sybrand Bakker
Senior Oracle DBA Received on Tue Dec 09 2003 - 08:54:44 CST

Original text of this message

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