Solved

privileges required for running dbms_stats other than sysdba

Posted on 2011-03-08
3
1,565 Views
Last Modified: 2012-05-11
What are previliges required to gather dbms_stats for a normal user.  i dont want to give sysdba ...
0
Comment
Question by:Dba_Oracledb
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
johnsone earned 250 total points
ID: 35074310
If the user that is running DBMS_STATS does not own the object, then I believe you need the ANAYLYZE ANY privilege.
0
 
LVL 3

Assisted Solution

by:CarlsbergFTW
CarlsbergFTW earned 250 total points
ID: 35074392
grant execute on dbms_stats to hr
0
 
LVL 3

Expert Comment

by:CarlsbergFTW
ID: 35074397
replace "HR" with the user that is supposed to be able to use this pack.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Getting a return value from an IN OUT parameter in Oracle? 7 52
data lookup in Oracle - need suggestions 55 113
clob to char in oracle 3 39
Oracle DBLINKS From 11g to 8i 3 32
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question