Re: running UTLRP.sql
Date: Fri, 14 Nov 2008 19:57:20 +0100
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
> 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.