Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recompiling invalid objects in PL/SQL
Jeremy wrote:
> In article <1134171805.528351_at_jetspin.drizzle.com>, DA Morgan says... >
> > > 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? >
USER1 will recompile the procedure, trigger, function (what ever PL/SQL)
the moment it is used, and invalid.
A possible error may occur when "revalidation" (as Oracle calls it)
fails.
So, there's no magic, Oracle does, and always has been doing, it when needed.
Why not try it? Create a table, and a procedure that manipulates that table. Grant execute to user2, test. Drop and recreate the table (this will invalidate the proc). Test again.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Sat Dec 10 2005 - 04:35:45 CST
![]() |
![]() |