Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_job - dbms_stats

Re: dbms_job - dbms_stats

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 27 Mar 2003 10:06:44 +0800
Message-ID: <3E825CB4.7B86@yahoo.com>


Ed Stevens wrote:
>
> Platform: Oracle 8.1.7 on Solaris
>
> I'm trying to set up a dbms_job to execute
> dbms_stats.gather_schema_stats. I've actually got it working, but am
> a bit puzzled by one thing. I found that I had to submit the job
> (exec dbms_job.submit) while logged on as the owner of the schema
> whose stats were being gathered. If I submitted the job while logged
> on as SYSTEM, the job would submit, but its execution would fail. Is
> this to be expected, or did I miss something in the docs?

Probably SYSTEM has its 'analyze any table', 'select any table' privs granted through the DBA role only, and thus no longer has that power when running through a procedure.

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"
Received on Wed Mar 26 2003 - 20:06:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US