Re: NewbieQ -- Auditing multiple tables

In article <30fcf672.4343523_at_news.visi.com>, sjh_at_visi.com (Steve Hallberg) writes:
> We are attempting to convert the company from Ingres- to Oracle-based
> applications, using no documentation and damned little technical help.
> So if this question is really really stupid, consider that I don't
> know much about what I'm trying to talk about.
 Get some documentation - you'll need it.
>
> Assume, say, three tables that are all updated by a single
> transaction. I need to know who updated those tables, when, and what
> the data looked like before and after the transaction. '

Audit insert,delete,update on table_name;

This will tell you when the action was applied and who applied it, but not what the data was. The results can be found in sys.aud$ or through the dba_audit_train, dba_audit_object..... views. These views contain OS login & oracle user ID identifiers.

remember to set the audit_trail=db option in you init.ora file.

The ORACLE DBA Handbook (by Kevin Loney, Oracle press) has some info in it on auditing but the Oracle7 Administrators Guide is probably the best.

If you need more help, email me.

Dave.

-- 
* * * * * * * * * * * * * *   dave  
* DSylva_at_colonial.com.au  *
* * * * * * * * * * * * * *   std disclaimers apply...