Re: Auditing Insert, update and deletes

From: David Trahan <DaveTrahan_at_sqlsecure.com>
Date: 1996/12/20
Message-ID: <59ecmu$clp@turing.direcpc.com>#1/1

Sunil Godithi <sunil_at_ameya.com> 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.)

SQL<>SECURE Audit Manager from BrainTree Technology does this through it's user defined auditing function. See http://www.sqlsecure.com. Received on Fri Dec 20 1996 - 00:00:00 CST