Re: Version control of Oracle Stored Objects.
From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 05 Mar 2005 23:37:54 GMT
Message-ID: <Xns96109F035CDF1SunnySD_at_68.6.19.6>
Date: Sat, 05 Mar 2005 23:37:54 GMT
Message-ID: <Xns96109F035CDF1SunnySD_at_68.6.19.6>
[Quoted] [Quoted] 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.
[Quoted] 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. Received on Sun Mar 06 2005 - 00:37:54 CET