• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3942
  • 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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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