Re: running UTLRP.sql

From: Peter Steinheuser <peter.steinheuser_at_enterprisedb.com>
Date: Fri, 14 Nov 2008 11:09:09 -0500
Message-ID: <c30da9e30811140809v28653f33tf505dba8271c7c58@mail.gmail.com>


You could wrap a procedure around it and then grant execute on the procedure to the users you want to run it.

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.
>
>
>
> 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
>
>
>

-- 
Peter Steinheuser
EnterpriseDB Corporation
499 Thornall Street
2nd Floor
Edison, NJ 08837
+1.732.331.1378 Office
+1.908.419.4220 Cell
+1.732.331.1301 Fax
peter.steinheuser_at_enterprisedb.com

http://www.enterprisedb.com
Built on open source. Compatible with Oracle(R).

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 14 2008 - 10:09:09 CST

Original text of this message