Re: running UTLRP.sql
- From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- To: John.Fedock@xxxxxxxxxxxx
- Date: Fri, 14 Nov 2008 10:30:48 -0600
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.
Bradd Piontek
"Next to doing a good job yourself,
the greatest joy is in having someone
else do a first-class job under your
direction."
-- William Feather
On Fri, Nov 14, 2008 at 10:00 AM, Fedock, John (KAM.RIC) <
John.Fedock@xxxxxxxxxxxx> 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.
>
>
>
> The doco states that a SYSDBA user can also:
>
> - Perform STARTUP and SHUTDOWN operations
>
> · ALTER DATABASE: open, mount, back up, or change character set
>
> · CREATE DATABASE
>
> · DROP DATABASE
>
> · CREATE SPFILE
>
> · ALTER DATABASE ARCHIVELOG
>
> · ALTER DATABASE RECOVER
>
> · Includes the RESTRICTED SESSION privilege
>
> 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*
>
> *"K"* Line America, ISD Department
>
>
>
Other related posts:
