MySQL Bugs: #86107: Table Privs in MySQL Workbench

Bug #86107	Table Privs in MySQL Workbench
Submitted:	27 Apr 2017 11:43	Modified:	27 Apr 2017 12:35
Reporter:	Eric Wagner	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S5 (Performance)
Version:	6.3.9	OS:	Windows (Microsoft Windows 7 Enterprise Service Pack 1)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
I've noticed there does not appear to be a way to perform TABLE specific grants to a user, nor (once granted on command line) are they visible in WorkBench

For example:

mysql> show grants for 'canv_int'@'canvintprod1.cc.emory.edu';
+---------------------------------------------------------------------------------------------------------------------------------+
| Grants for canv_int@canvintprod1.cc.emory.edu                                                                                   +---------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'canv_int'@'canvintprod1.cc.emory.edu' IDENTIFIED BY PASSWORD 'XXXXX' |
| GRANT SELECT, INSERT, UPDATE, DELETE ON `canvas_imports`.* TO 'canv_int'@'canvintprod1.cc.emory.edu'                            |
| GRANT DROP ON `canvas_imports`.`stage_courses` TO 'canv_int'@'canvintprod1.cc.emory.edu'                                        |
| GRANT DROP ON `canvas_imports`.`stage_enrollments` TO 'canv_int'@'canvintprod1.cc.emory.edu'                                    |

You can see the DROP grants I made, but MySQL does not show them.

How to repeat:
Each time MySQL WorkBench is used to review Users and Privs.

Hello Eric Wagner,

Thank you for the report and feedback.
This is duplicate of existing feature request Bug #61066

Thanks,
Umesh