-
dbms_stats procedure privs
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,
-
I remember when this place was cool.
-
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)...
Jeff Hunter
-
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,
-
does the stat table exist?
-
yes, table does exist and I even create the synonym pointing to that table.
-
have you been granted permission to it explicitly (ie. not through a role)?
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|