Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Auditing question
"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