Re: Database comparisons

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: oracledba.williams@xxxxxxxxx
  • Date: Mon, 11 Jan 2010 09:45:01 -0800

On Mon, Jan 11, 2010 at 9:24 AM, Dennis Williams <
oracledba.williams@xxxxxxxxx> wrote:

> List,
>
> We have an audit finding related to data integrity. I'm looking for a way
> to detect all database changes on a small test database. Fortunately the
> environment is well-contained. Typically when we've made application
> changes, we verify that the data changes are what we expect. The auditors
> are insisting that we somehow verify there aren't unexpected changes in
> other tables. The environment is Oracle 10.2.0.4 on Solaris. I have three
> thoughts:
>
>

Is regression testing performed on the app when it is changed, before
applying to production?

Wouldn't that be sufficient to satisfy the auditors?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

Other related posts: