RE: Database comparisons

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Mon, 11 Jan 2010 15:23:59 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F36AF5142_at_AAPQMAILBX02V.proque.st>

After reading along on this thread for a while, I'm *so* thankful I work for a privately held company and so not subject to SOX! :)

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Monday, January 11, 2010 3:14 PM
To: oracledba.williams_at_gmail.com
Cc: Niall Litchfield; oracle-l_at_freelists.org Subject: Re: Database comparisons

On Mon, Jan 11, 2010 at 11:38 AM, Dennis Williams <oracledba.williams_at_gmail.com<mailto:oracledba.williams_at_gmail.com>> 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". I wasn't involved in the original question that led to the finding.

If I understand this correctly, the changes referred to are made as part of the process to apply development changes to production.

Is that correct?

If so, DML triggers could be temporarily placed on the apps tables to capture what was done, store the changes in another set of tables, and drop/disable the triggers.

There are many methods to accomplish that, but this one makes reporting a bit easier.

Assuming my assumption was correct that is. :)

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 - 14:23:59 CST