Bug #26778 automatic_sp_privileges doesn't work as documented
Submitted: 2 Mar 2007 0:14 Modified: 2 Mar 2007 7:56
Reporter: Sarah Sproehnle Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S3 (Non-critical)
Version:5.x OS:
Assigned to: CPU Architecture:Any

[2 Mar 2007 0:14] Sarah Sproehnle
Description:
This variable doesn't seem to work correctly.  It is on (the default).  A user has CREATE ROUTINE privilege.  The user makes a new stored procedure and then attemps to CALL the procedure.  This produces an error (ERROR 1370 (42000): execute command denied for user 'sakila'@'localhost' for routine 'test.p')

How to repeat:
GRANT CREATE ROUTINE ON test.* TO user@host IDENTIFIED BY 'pass'

Log in with new user account.
CREATE PROCEDURE p () SELECT 'hello';
CALL p(); -- results in error
SHOW GRANTS; -- reveals that the user only has CREATE, not EXECUTE privilege
[2 Mar 2007 7:56] Sveta Smirnova
Thank you for the report.

I can not repeat it with last development sources.