Re: Recompiling invalid objects in PL/SQL

In article <1134171805.528351_at_jetspin.drizzle.com>, DA Morgan says...
> 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.
>

In this scenario USER1 owns all the packages. USER2 has access to execute the packages via a role. The packages have public synonyms.

Unless USER2 is given the privilege to alter procedures, is there a way that the automatic recompilation can be triggered?

-- 

jeremy