Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_job - dbms_stats
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