Re: Database comparisons
From: Gus Spier <gus.spier_at_gmail.com>
Date: Mon, 11 Jan 2010 20:42:24 -0500
Message-ID: <6d3967611001111742s5567c638x9b087659b74cb345_at_mail.gmail.com>
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.
Date: Mon, 11 Jan 2010 20:42:24 -0500
Message-ID: <6d3967611001111742s5567c638x9b087659b74cb345_at_mail.gmail.com>
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?
r,
Gus
On Mon, Jan 11, 2010 at 6:43 PM, GovindanK <gkatteri_at_fastmail.fm> 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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 11 2010 - 19:42:24 CST