Re: Version control of Oracle Stored Objects.

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 05 Mar 2005 18:56:50 -0800
Message-ID: <1110077619.499872@yasure>

IANAL_VISTA wrote:

> DA Morgan <damorgan_at_x.washington.edu> wrote in
> news:1110065133.857196_at_yasure:
>

>>The real BDFH builds a DDL trigger that raises an exception with all DDL
>>on the database and another that audits it. He/she then disables the
>>first trigger whenever making changes leaving the second one to create
>>the audit trail.

>
>
> Alternatively, just nightly extract the current production code from the
> repository and install it into the database. Any and all ad hoc, on the
> fly or unapproved changes just get summarily overwritten.

And you do this with users connected? ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Sat Mar 05 2005 - 20:56:50 CST