Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Preventing compilations......
Miggins wrote:
> Hi,
>
> Am wondering if there is a way of preventing the compilation of
> packages in a schema. We have source control inb the form of source
> safe but this does not prevent people compiling different versions
> against the database.
>
> Is it possible for a developer to "lock" a package and prevent other
> developers making changes?
>
> Thanks
Don't grant access as the schema owner. Rather grant access only with the execute privilege.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Mon Feb 27 2006 - 12:00:25 CST