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
• Status: Verified
• Category: MySQL Server: Information schema
• Severity: S4 (Feature request)
• Version: 5.0+
• OS: Any
• 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.