Re: running UTLRP.sql

How about a stored procedure that does the same thing as utlrp.sql. Create it to run as the owner (a SYSDBA user) and only grant privs to execute it to the users you want to be able to use this functionality.

Finn

On Fri, Nov 14, 2008 at 11:00 AM, Fedock, John (KAM.RIC) < John.Fedock_at_us.kline.com> wrote:

> For 10.2.0.3, HP-UX, the header in the script clearly states you must be
> a user with SYSBDA privs to run.
>
> After code changes, we run utlrp.sql to recompile invalidated objects.
> We would like some users to run this, but not any with a SYSDBA privs. Any
> ideas? Maybe a Unix script that they can execute that will run and do
> this? Just looking for fresh ideas.
>
> TIA,
>
>
>
> *John Fedock*
>

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