• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4390
  • Last Modified:

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 ...
0
Dba_Oracledb
Asked:
Dba_Oracledb
  • 2
2 Solutions
 
johnsoneSenior Oracle DBACommented:
If the user that is running DBMS_STATS does not own the object, then I believe you need the ANAYLYZE ANY privilege.
0
 
CarlsbergFTWCommented:
grant execute on dbms_stats to hr
0
 
CarlsbergFTWCommented:
replace "HR" with the user that is supposed to be able to use this pack.
0
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now