DBMS_STATS and privileges - preCharge Forums
It shows that you are unregistered. Please register with us by clicking Here
preCharge Forums


Nav Green LeftRegister - FAQ - Today's Posts - New Posts - Support - SearchNav Right
preCharge Forums > Website Design & Development > Programming » DBMS_STATS and privileges


Reply
Tcat Right
 
LinkBack Thread Tools Display Modes Tcat Right
Old 08-01-2006   #1 (permalink)
cameron
Junior Member
 
Join Date: Jul 2006
Age: 41
Posts: 27
Default DBMS_STATS and privileges
I'm trying to run DBMS_STATS.GATHER_SCHEMA_ STATS from within a stored procedure.

The user running it has DBA role, but I know that "sometimes" or all the time, privileges through a role doesn't work with stored procedures.

I've already granted analyze any and execute on sys.dbms_stats directly to the user
thanks
cameron
cameron is offline   Reply With Quote


Reply

« Oracle Forms migration problems | Ora-01017 »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


footer left
All times are GMT. The time now is 01:18 PM.
Contact Us - preCharge.Net - Archive - Privacy Statement - Top

DISCLAIMER: preCharge Risk Management is not responsible for any opinions, advice or comments expressed on the preCharge Community Forums.
preCharge® is a registered trademark of preCharge Risk Management | chargeback protection | Merchant Account Blog

Powered by vBulletin
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0 RC6

Remortgages | Mobile Phone deals | Loans | Debt Help | Mortgage Calculator

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49