Bug #73221 Extra row in column privileges
Submitted: 7 Jul 2014 17:34 Modified: 28 Aug 2014 0:38
Reporter: Todd Farmer (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.1.7 OS:Any
Assigned to: CPU Architecture:Any

[7 Jul 2014 17:34] Todd Farmer
The table inspector grants tab provides visibility into grants for a given table, including at the column level.  The column privileges listed, however, seem to include an extra row, suggesting a scope at the table level (see screenshot) - even when the privileges are granted only for specific columns.

How to repeat:
1.  CREATE USER colpriv@localhost;
2.  GRANT SELECT (user, host) ON mysql.user TO colpriv@localhost;
3.  Use WB table inspector to view grants for mysql.user table.
4.  Observe three rows in "column privileges" section.

Suggested fix:
Remove rows from "column privileges" which are not column-level privileges.
[28 Aug 2014 0:38] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.2.2 release, and here's the changelog entry:

The "column privileges" section in the Table Inspector contained an extra
third column.

Thank you for the bug report.