Granting Access to a Procedure

[Fuzemmo]

New to MySQL here and am running version 5.0.16. I've created a simple procedure that I can execute as root. I've created another user that will be used to make my connection from the web. Testing this login, I cannot execute the procedure.

I've looked, but can only find ways to grant access to table ojects, not to the procedure that I've created.

How do I do this and/or what are some decent tools that are commonly recommended for these types of admin as well as development tasks.

Thanks.

 

[sleipnir214]

According to

http://dev.mysql.com/doc/refman/5.0/en/grant.html,

you should be assigning the EXECUTE permission.

Want the best answers? Ask the best questions!

TANSTAAFL!!