MySQL Forums
Forum List  »  Stored Procedures

select privilege on proc table of mysql needed to execute an SP?
Posted by: Chagh
Date: August 28, 2005 02:58AM

hi all,

Does select privilege on proc table of mysql needed to execute an SP?
i've read the manual and i found just execute priv. is needed for this.

I have MySQL 5.0.7. it is connecting to .Net using Mysqlconnector/net. i have a test DB which contains a test table and an SP.

i created a user with all privileges on test db (grant all on test.* to username). this user should connect fron .Net app. and execute the SP.

when trying to do so, i get an
error message "42000 select command denied to user username@'IP' for table proc". this error remains if i state seperately execute privilege to user on the SP.

but when i add select privilege on mysql.proc it can connect and execute the SP.

Thanks in advance
Chagh

Options: ReplyQuote


Subject
Views
Written By
Posted
select privilege on proc table of mysql needed to execute an SP?
17088
August 28, 2005 02:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.