Privileges required for Job to analyze_schema ?

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 - 06:05:46 CDT