Re: Q: Disable Table Lock Experiences

Lee

I wouldn't disable the functionality in Development. Production maybe, but not Development. A couple of problems you might run up against:

1. If the developers have owner access, which is often the case in development environments, they can just change it back again.
2. How are you going to let them build and drop indexes for performance testing etc.?

Is there really a need to be so secure in a development environment?

Pete

Lee Parsons wrote:

> I'm planning to use the "alter table <...> disable table lock" command in one of my development
> environments to keep my developers from altering my tables and randomly adding indexes.
> When we need to change the table structure we'll just enable the lock and disable it when
> we're done.
>
> Any one have any experience with this? Any unintended concequences?
> Please copy replys to lparsons_at_eskimo.com.
>
> Thanks,
> Lee

--
Regards

Pete

Received on Thu Jul 15 1999 - 13:59:15 CDT