Jeremy wrote:
> In article <dn6qlh$qef$1_at_news6.zwoll1.ov.home.nl>, Frank van Bortel
> says...
>
>>Apart from all the good examples, do you realize Oracle will
>>recompile on an 'as needed' base?
>>So, unless you're not sure weather everything actually will
>>compile, there is no reason to.
>>
>
>
> Not necessarily - I beileve that the user trying to execute a package
> that is invalid will need to have some specific privilege such as
>
> SQL> grant alter any procedure to <user>;
>
> Unless this has changed in 10g?
>
Depends on who owns it.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Dec 09 2005 - 17:43:25 CST
