Re: Database comparisons

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 11 Jan 2010 09:45:01 -0800
Message-ID: <bf46381001110945x6452996fnddb5b085e9c61726_at_mail.gmail.com>

On Mon, Jan 11, 2010 at 9:24 AM, Dennis Williams < oracledba.williams_at_gmail.com> 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

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

Received on Mon Jan 11 2010 - 11:45:01 CST