My databases are hosted on a LP shared server running MySQL version "5.0.<something>.ourdelta".

I can create stored procedures successfully. But there appears to be no way to grant EXECUTE permissions on stored procedures. I tried executing a GRANT statement using a database user that is supposed to have "ALL" rights - the GRANT fails due to lack of GRANT permission. It appears the only user that can execute them is the user that created them. This presents a problem when the stored procedures will be executed by a limit-rights user under which a web site runs.

So what gives? Are stored procedures supported on LP hosted MySQL databases? If so, exactly how does one grant EXECUTE permission to a user other than the one that created it?

Thanks.

I believe that the reason why you are not able to issue the GRANT statement is because the GRANT ALL PRIVILEGES command does not transfer the GRANT OPTION privilege.  That which needs to be granted separately by someone else who has it (or root if no one has received it yet).  Once that has been done, you can create a new user with only the EXECUTE privilege.  If you would like to limit existing users and you have been granted ALL and GRANT OPTION then you can REVOKE all of their PRIVILEGES except EXECUTE.

Let me know if this achieves what you were hoping for.

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

Bassette