Bug #26886 No ROUTINE_PRIVILEGES table in INFORMATION_SCHEMA
Submitted: 6 Mar 2007 17:36 Modified: 6 Mar 2007 19:37
Reporter: Max Mether Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:5.1 OS:Any
Assigned to: Sergey Glukhov CPU Architecture:Any
Triage: Triaged: D5 (Feature request)

[6 Mar 2007 17:36] Max Mether
Description:
There is currently no ROUTINES_PRIVILEGES table in the INFORMATION_SCHEMA schema. This makes it impossible to create routines for managing users by just using the IS tables and GRANT and REVOKE statements. Instead the mysql schema has to be used which we do not recommend

How to repeat:
mysql> SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='INFORMATION_SCHEMA' AND TABLE_NAME LI
KE '%PRIVILEGES';
+-------------------+
| TABLE_NAME        |
+-------------------+
| COLUMN_PRIVILEGES |
| SCHEMA_PRIVILEGES |
| TABLE_PRIVILEGES  |
| USER_PRIVILEGES   |
+-------------------+
4 rows in set (3.29 sec)
[6 Mar 2007 19:37] Valeriy Kravchuk
Thank you for a problem report. Verified just as described with latest 5.1.17-BK.
[22 Sep 2008 13:53] Miguel Solorzano
Bug: http://bugs.mysql.com/bug.php?id=39587 has been marked as duplicate of this one.