Bug #61596 Missing procs_priv equivalent table in INFORMATION_SCHEMA
Submitted: 22 Jun 2011 8:18 Modified: 22 Jun 2011 19:48
Reporter: Shlomi Noach (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:>= 5.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: information_schema, routines, Security

[22 Jun 2011 8:18] Shlomi Noach 
Description:
INFORMATION_SCHEMA provides with four privileges tables: USER_PRIVILEGES, SCHEMA_PRIVILEGES, TABLE_PRIVILEGES, COLUMN_PRIVILEGES, which map to mysql‘s user, db, tables_priv and columns_priv tables, respectively.

There is no INFORMATION_SCHEMA table which maps to mysql.procs_priv.

This makes for an inconsistency with I_S schema privileges tables.

How to repeat:
SHOW TABLES FROM INFORMATION_SCHEMA;

Suggested fix:
Add INFORMATION_SCHEMA.ROUTINES_PRIVILEGES table
[22 Jun 2011 9:20] Valeriy Kravchuk 
Thank you for the problem report. Verified with 5.5.11 (proxies_priv table from mysql database there also has no equivalent in I_S...)
[22 Jun 2011 17:37] Peter Gulutzan 
This looks like a duplicate of
Bug#26886 No ROUTINE_PRIVILEGES table in INFORMATION_SCHEMA
[22 Jun 2011 19:31] Shlomi Noach 
Yes, it seems like a duplicate
[22 Jun 2011 19:48] Shlomi Noach 
You might want to look at:
http://code.openark.org/blog/mysql/routine_privileges-implementation

For expected output sample.