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_at_yasure>
>
>
> 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.
Date: Sat, 05 Mar 2005 18:56:50 -0800
Message-ID: <1110077619.499872_at_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 Sun Mar 06 2005 - 03:56:50 CET