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:Microsoft Windows (WinXP)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: User Management

[7 Jul 2006 23:07] Peter Laursen
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!
[7 Jul 2006 23:09] Peter Laursen
screenshot of MA and returns of SHOW GRANTS after GRANT ALTER ROUTINE ...

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

[8 Jul 2006 22:05] Miguel Solorzano
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.
[8 Jul 2006 22:10] Peter Laursen
Yes, of course :-)

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

this is a 'bundle' of all 4 MySQl gui tools.
[8 Jul 2006 23:33] Miguel Solorzano
Thank you for the feedback.
[10 Jul 2006 3:00] KimSeong Loh
I notice the same problem in 1.1.9 too
[8 Sep 2006 9:55] Vladimir Kolesnikov
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