I am trying to use the DBMS_STATS package to analyze do a schema level analyze....this job that calls the stats package is executed by a user who is not the the owner of the schema being analyzed. I have granted the user who is running the DBMS_STATS the analyze any privilege however the job keeps failing with:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_STATS"
errors.........do I need to assign other priviliges...has any one had similar problems when trying to run this package...please help