Bug #26886 No ROUTINE_PRIVILEGES table in INFORMATION_SCHEMA

• Submitted: 6 Mar 2007 17:36
• Modified: 6 Mar 2007 19:37
• Reporter: Max Mether
• Status: Verified
• Category: MySQL Server: Information schema
• Severity: S4 (Feature request)
• Version: 5.1
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[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] MySQL Verification Team

Bug: http://bugs.mysql.com/bug.php?id=39587 has been marked as duplicate of this one.