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

I haven't checked whether this would work, but look at a DDL trigger at database level to catch 'alter' and/or 'create' and raise an error if appropriate

hth

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------