10/08/2007

MySql Stored Procedures Execute Privileges

Just as a reminder to myself and the Tim Crew into databases I'm posting this.
When using SPs on MySql you need to grant execute privileges to the procedure to actually be able to use it. (IMHO if you can create it you should think one could use it but maybe thats just me.)
GRANT EXECUTE ON PROCEDURE db_name.sp_name TO 'some_user'@'some_host';

You can use wildcards if you like...
GRANT EXECUTE ON PROCEDURE *.* TO 'some_user'@'some_host';

No comments: