privileges required for running dbms_stats other than sysdba

What are previliges required to gather dbms_stats for a normal user. i dont want to give sysdba ...

Dba_Oracledb

Asked: 2011-03-08

Advertise Here

2 Solutions

johnsoneSenior Oracle DBACommented: 2011-03-08

If the user that is running DBMS_STATS does not own the object, then I believe you need the ANAYLYZE ANY privilege.

CarlsbergFTWCommented: 2011-03-08

grant execute on dbms_stats to hr

CarlsbergFTWCommented: 2011-03-08

replace "HR" with the user that is supposed to be able to use this pack.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment Already a member? Login.