Bug #50770 INFORMATION_SCHEMA TABLE_PRIVILEGES and COLUMN_PRIVILEGES are missing GRANTOR
Submitted: 31 Jan 2010 20:29 Modified: 31 Jan 2010 21:27
Reporter: Lawrenty Novitsky Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:5.0+ OS:Any
Assigned to: CPU Architecture:Any
Tags: COLUMN_PRIVILEGES, GRANTOR, TABLE_PRIVILEGES

[31 Jan 2010 20:29] Lawrenty Novitsky
Description:
TABLE_PRIVILEGES and COLUMN_PRIVILEGES tables of INFORMATION_SCHEMA don't have GRANTOR field.
While mysql.tables_priv has that field.

Docs say field is omitted. So possibly there is purpose of that.

There is need to change respective odbc calls implementations to use I_S instead of mysql.* tables in the myodbc driver. So adding GRANTOR field will be appreciated, as we will have to return NULL for it before it's done.

How to repeat:
desc INFORMATION_SCHEMA.TABLE_PRIVILEGES;
desc INFORMATION_SCHEMA.COLUMN_PRIVILEGES;
desc mysql.tables_priv;

Suggested fix:
Add GRANTOR field to the mentioned I_S tables
[31 Jan 2010 21:27] Valeriy Kravchuk
I'd say that this is just a bug. We should be consistent.