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?
>
Surely, only when running with current user, not when running
with creator privileges (the default)
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Fri Dec 09 2005 - 15:00:45 CST
