Re: Options for auditing data changes

have you looked at flashback data archive?. Could be a good fit

http://www.oracle.com/technetwork/issue-archive/2008/08-jul/flashback-data-archive-whitepaper-129145.pdf

best regards

On Tue, Mar 22, 2011 at 4:30 PM, Sreejith S Nair < Sreejith.Sreekantan_at_ibsplc.com> wrote:

> Hi Friends,
>
> I thought I will get some inputs on my following implementation. The
> requirement is to audit some data changes with in the system.( Oracle 10.2
> on RHEL 4.7 )
> The audit is required in a sense that, the before images of data and
> information of who changed the data is required. I have looked at options
> like Oracle Auditing,FGA and so. But this cannot give me audit for the data
> changes,when and who changed.
>
> The first thing that comes into my mind are using triggers . Another option
> is using log miner. I have successfully tested it out with both of these
> approaches. The environment is like
>
> 1 ) For some critical tables for which audit is required triggers were
> written ( ours is an OLTP application )
> 2 ) For some non critical tables, log miner which was called by a stored
> procedure which runs at certain periods is used.
> 3 ) audit data is stored in a different schema , with same table names as
> in base schema.
>
> I would like to know your thoughts on this.
>
> Thank You,
>
> Kind Regards,
> Sreejith Nair
>
>
>
>
>
>
>
> DISCLAIMER:
>
> "The information in this e-mail and any attachment is intended only for the
> person to whom it is addressed and may contain confidential and/or
> privileged material. If you have received this e-mail in error, kindly
> contact the sender and destroy all copies of the original communication. IBS
> makes no warranty, express or implied, nor guarantees the accuracy, adequacy
> or completeness of the information contained in this email or any attachment
> and is not liable for any errors, defects, omissions, viruses or for
> resultant loss or damage, if any, direct or indirect."
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l