dbms_stats procedure privs

[matthew00]

Hi all,

I have a procedure, inside the procedure is DBMS_STATS package to update the stats, any way, the procedure was created in a DBA account to update stat on schemas named TEST in the database. If I run the procedure manually, proc ran ok; however, if I put the proc into the dbms_jobs to runt the proc then it failed. what privs am I missing???

thanks,

[Mr.Hanky]

Execute on DBMS_STATS?

[marist89]

You're getting your privs from a role, not assigned directly to you. Find out what's in the role and that's what you need (more or less)...

[matthew00]

looking into the trace files, I think I have problem with dbms_stats.import_table_stats/ USER_STATTAB tables, I got the errors:

ORA-12012: error on auto execute of job 218
ORA-20000: Table USER_STATTAB does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 4837
ORA-06512: at "SYS.DBMS_STATS", line 5467


what privilege do I need?

thanks,

[davey23uk]

does the stat table exist?

[matthew00]

yes, table does exist and I even create the synonym pointing to that table.

[marist89]

have you been granted permission to it explicitly (ie. not through a role)?