MySQL Forums
Forum List  »  MySQL Administrator

stored procedures editor and privileges
Posted by: Bar Mo
Date: April 20, 2010 06:41AM

I need to give a user enough privileges to view and edit stored procedures in a given database using mysql administrator. So far I've issued:

grant ALL on db.*
grant create routine on db.*
grant alter routine on db.*
grant execute on procedure db.proc1

which should be more than enough, but user still doesn't even see procedure body in mysql administrator (list of procedures is visible, but after clicking "Edit" body is empty).

What am I missing?

Options: ReplyQuote

Written By
stored procedures editor and privileges
April 20, 2010 06:41AM

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.