Re: 11gR2 - auditing row changes

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 18 Aug 2013 15:05:06 +0000 (UTC)
Message-ID: <pan.2013.08.18.15.05.06_at_gmail.com>

On Sun, 18 Aug 2013 12:20:29 +0100, Jeremy wrote:

> Hi we are running 11gR2 standard edition.
>
> A business requirement has emerged which means that potentially a user
> would like to be able to see what columns have cheanged on each update
> to a row in one of several tables.

You can create a trigger and create your own audit table. You can also use system auditing, in conjunction with the Log Miner, which is by far the most complex method. You can also use virtual private database.

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com

Received on Sun Aug 18 2013 - 17:05:06 CEST