Re: Database comparisons

  • From: Gus Spier <gus.spier@xxxxxxxxx>
  • To: gkatteri@xxxxxxxxxxx
  • Date: Mon, 11 Jan 2010 20:42:24 -0500

Can some kind of checksum be used to demonstrate the non-target tables
haven't changed?  I haven't thought this out yet, but it seems that if we
can logically isolate the non-target tables, contrive some kind of check sum
on their values, we might have an easy indicator that nothing has changed in
them after the target table has been modified.

What do you think?



On Mon, Jan 11, 2010 at 6:43 PM, GovindanK <gkatteri@xxxxxxxxxxx> wrote:

>  > *The auditor's question was essentially that "you are making changes to
> table A and verifying those changes, but how do you know the application
> didn't also change table B".*
> If that be the concern, then the following should help
> audit_trail= db / db,extended
> audit alter table on <user> , audit create table on <user>
> Query dba_audit_object
>  HTH
> GovindanK

Other related posts: