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: Dusan Bolek <pagesflames_at_usa.net>
Date: 9 Dec 2003 07:40:25 -0800
Message-ID: <1e8276d6.0312090740.37dbffa1@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 ?

Using the specified configuration you should have audit rows stored in sys.aud$ table. Please look into a documentation for information about structure of this database table. Everything you wanted (when, who etc.) is already there accessible by simple queries.

--
with regards

Dusan Bolek
Received on Tue Dec 09 2003 - 09:40:25 CST

Original text of this message

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