Re: running UTLRP.sql
Date: Sat, 15 Nov 2008 12:22:13 +0800
This does not run as SYS, but as the calling user.
Thus, account 'HEMANT' owning code objects (Views, Procedures etc)
DBMS_UTILITY.COMPILE_SCHEMA('HEMANT'); without having DBA privieleges.
At 12:00 AM Saturday, Fedock, John \(KAM.RIC\) 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.
>"K" Line America, ISD Department
Hemant K Chitale