Re: running UTLRP.sql

or build a calling wrapper around the procedures of definer rights package SYS.UTL_RECOMP which is used behind the script utlrp.sql this wrapper may limit the recompilation to certain schemas depending on the caller

kf

>
> What exactly is it you are trying to accomplish? If it is to re-
> validate objects after a change, there are other ways to go about it
> than using utlrp.sql . You could wrap DBMS_UTILITY.COMPILE_SCHEMA in
> a package that certain users/roles could call. You could also find,
> via web search, a myriad of scripts that do a similar things.
>

--
http://www.freelists.org/webpage/oracle-l