Re: Auditing question

R.B wrote:

> 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

If finding DDL information is all you are trying to do I'd stop the auditing and build a DDL trigger that loads the information you want into a table anywhere you want it. And any simple SQL statement will retrieve it.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)