Re: Privileges required for Job to analyze_schema ?

It could be that when you run the job in the schema, the priv is enabled via a role granted to it but under dbms_utility, roles *may* not be enabled (if it is consistent with dbms_sql).
Try allocating the ANALYZE ANY system priv directly against the schema and try again.

HTH Mark

Kevin A Lewis wrote in message ...
>I have set up a Job to run each night to perform the package DBMS_UTILITY
>and the procedure ANALYZE_SCHEMA. This works online under the SYSTEM user
>against another schema, but will not successfully run the job.
>
>The error given is
>
>*** SESSION ID:(11.4411) 1999.07.12.10.49.34.093
>ORA-12012: error on auto execute of job 81
>ORA-20000: You have insufficient privileges for an object in this schema.
>ORA-06512: at "SYS.DBMS_UTILITY", line 257
>ORA-06512: at line 1
>
>Fine but how do I go about finding what privileges are being requested,
>particularly when you cannot see into the proceedure code.
>
>Regards
>
>--
>Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)
> <KevinALewis_at_HotMail.com>
>
>The views expressed herein by the author of this document
>are not necessarily those of BOCM PAULS Ltd.
>
>
Received on Mon Jul 12 1999 - 07:46:27 CDT