Re: running UTLRP.sql
- From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- To: bbel5@xxxxxxxxxxxx
- Date: Fri, 14 Nov 2008 10:44:11 -0600
FYI: The privilege to truncate other tables is "DROP ANY TABLE". I've never
liked the fact that you had to grant this to truncate another users tables.
UTLRP.sql must be ran as SYS. It fails miserably if you aren't.
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:19 AM, Bellows, Bambi (Comsys) <
bbel5@xxxxxxxxxxxx> wrote:
> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *SHEEHAN, JEREMY
> *Sent:* Friday, November 14, 2008 10:06 AM
> *To:* John.Fedock@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> *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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Fedock, John (KAM.RIC)
> *Sent:* Friday, November 14, 2008 11:01 AM
> *To:* oracle-l@xxxxxxxxxxxxx
> *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
>
>
>
Other related posts:
