Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Preventing compilations......

Re: Preventing compilations......

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 27 Feb 2006 10:00:25 -0800
Message-ID: <1141063220.261096@jetspin.drizzle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US