RE: running UTLRP.sql
Date: Fri, 14 Nov 2008 10:19:04 -0600
Message-ID: <AD0CB572A820AB4E8E52ABD38950FD3605803E63@a0001-xpo0150-s.hodc.ad.allstate.com>
Or you could just grant the underlying privileges...
The only thing I've run into so far that really *does* require a DBA account (and maybe other people have run into others) are jobs which require the truncation of tables from a schema which does not own those tables... seems you just can't grant that right. Well, maybe you can now, that *was* years ago... Still...
HTH, Bambi.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of SHEEHAN, JEREMY
Sent: Friday, November 14, 2008 10:06 AM
To: John.Fedock_at_us.kline.com; oracle-l_at_freelists.org
Subject: RE: running UTLRP.sql
Why not just create a job that runs this periodically? You can run it every 3 hours and have it run by a generic sysdba account.
Jeremy
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fedock, John
(KAM.RIC)
Sent: Friday, November 14, 2008 11:01 AM
To: oracle-l_at_freelists.org
Subject: running UTLRP.sql
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 14 2008 - 10:19:04 CST