stored procedures editor and privileges
Posted by:
Bar Mo
Date: April 20, 2010 06:41AM
hello,
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?
Subject
Written By
Posted
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.