Execute privilege?

[tupakapoor]

Hey guys,

I'm having the same problem as here:
http://forums.x10hosting.com/free-hosting/75812-execute-privilege.html

But that thread was closed without any response. How do we go about getting privileges to run stored procs?

TIA!

--tupakapoor
Edit:
just for good measure, this is the error i get:

execute command denied to user 'kapoora_dtmmblb'@'localhost' for routine 'kapoora_dtmmblb.AddRating'

I created the procedure through phpMyAdmin.

 

[tupakapoor]

bump?

 

[tupakapoor]

still no word?

 

[tnl2k7]

Have you assigned all privileges to the user attached to that database?

 

[tupakapoor]

Yes, from cPanel. but 'execute' isn't one of the privileges listed, and when i try to grant that privilege via sql commands in phpMyAdmin I get a message saying i dont have permissions to run the grant command.

Edit: went back to cPanel and noticed there was a "All Privileges" checkbox above the individual selections - I'll test again after checking that box and get back to you.

 

[Christopher]

If the all privileges check box doesn't work then it is disabled.

 

[tupakapoor]

Yup, didn't work. Any possibility of allowing that? What's the rationale behind disabling stored procs?

 

[Christopher]

Moved to level two support