Re: Auditing Insert, update and deletes

Sunil Godithi wrote:
>
> Hi,
> I have a need to audit inserts, updates, and deletes in existing
> application.
> the application has over 200 Tables ( oracle 7.1.6). We need to know who
> changed what column to what value.
>
> I'd like to know if anyone had come across this problem, If so how did
> they solve it. I'd hate to create 200 history tables or Write code to
> check which column was changed in every trigger separately. (Some of
> these tables have a lot of columns.)
>
> One Idea someone suggested was to reverse engineer the database into
> Des2K and use the audit option to generate the 200 + tables and database
> triggers.

  Using triggers are inevitable as it is the way to implement value-based audit options. Anyway, you can write some scripts to generate the trigger definitions by using USER_TABLES and other tables without reverse engineering.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841