Re: running UTLRP.sql

From: Hemant K Chitale <>
Date: Sat, 15 Nov 2008 12:22:13 +0800
Message-Id: <>

This does not run as SYS, but as the calling user.

Thus, account 'HEMANT' owning code objects (Views, Procedures etc) could execute
DBMS_UTILITY.COMPILE_SCHEMA('HEMANT'); without having DBA privieleges.

At 12:00 AM Saturday, Fedock, John \(KAM.RIC\) wrote:
>For, 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.
>John Fedock
>"K" Line America, ISD Department

Hemant K Chitale

Received on Fri Nov 14 2008 - 22:22:13 CST

Original text of this message