Re: Version control of Oracle Stored Objects.

[Quoted] In message <1110077619.499872_at_yasure>, DA Morgan <damorgan_at_x.washington.edu> writes
>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? ;-)
>
I assume he means the development database. i.e. refresh the development [Quoted] database with the current production (or other appropriate phase) code.

Developers need to learn to start the day by reapplying their current working changes. The mostly do.

-- 
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>