MySQL Bugs: #20911: global routine privileges are missing

Bug #20911	global routine privileges are missing
Submitted:	7 Jul 2006 23:07	Modified:	8 Sep 2006 9:55
Reporter:	Peter Laursen (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.1	OS:	Windows (WinXP)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any
Tags:	User Management

Description:
1) (MA bug)
MA 'Global Privileges' tab do not have 'CREATE ROUTINE' and 'ALTER ROUTINE' priv's available.

It is possible to execute "Grant create routine on '.' to 'user'@'host' " for instance.  "Show Grants ..." returns the privlege OK after that

Docs at http://dev.mysql.com/doc/refman/5.0/en/grant.html say:
"The CREATE ROUTINE, ALTER ROUTINE, EXECUTE, and GRANT privileges apply to stored routines (functions and procedures). They can be granted at the global and database levels. Also, except for CREATE ROUTINE, these privileges can be granted at the routine level for individual routines and are stored in the mysql.procs_priv table." 

2) (Documentation request)
Now please also explain "GRANT privilege apply to stored routines".
The table below this statements does not mention the GRAANT privilege!
This is cryptical to me!

How to repeat:
N/A ...

Suggested fix:
I second that!

screenshot of MA and returns of SHOW GRANTS after GRANT ALTER ROUTINE ...

Attachment: routineprivs.jpg (image/jpeg, text), 143.85 KiB.

Thank you for the bug report. Currently at:
http://dev.mysql.com/downloads/administrator/1.1.html
the version for download is 1.1.9 and you are reporting
version 1.2.1. If the version reported is correct could
you please provide me the URL you got it.

Thanks in advance.

Yes, of course :-)

From here:
http://dev.mysql.com/downloads/gui-tools/index.html

this is a 'bundle' of all 4 MySQl gui tools.

Thank you for the feedback.

I notice the same problem in 1.1.9 too

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html