MySQL Bugs: #55224: GUI administration functions missing from Workbench

Bug #55224	GUI administration functions missing from Workbench
Submitted:	13 Jul 2010 17:06	Modified:	13 Jul 2013 3:18
Reporter:	Michael Schechter	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S4 (Feature request)
Version:	5.2.25	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any

Description:
In addition to the user privilege functionality currently provided in MySQL Workbench, the old MySQL Administrator tool allowed the following functionality for privilege management:
1) Discrete global privilege assignment (Workbench only supports assignments by predefined group)
2) Table privilege management
3) Column privilege management
4) Other schema object privilege management

This has also been partly referenced in bug 52977 and bug 54141; I have created this bug because the deficiency is larger than the scope of those bugs.

How to repeat:
To see missing functionality
1) Open MySQL Administrator
2) Click on "User Administration"
3) Select a specific user/host combination from the "Users Accounts" list
4) Click on the "Blobal Privileges" and "Schema Object Privileges" tabs

In MySQL Workbench, open a "Server Administration" instance
1) Click on "Accounts"
2) Click on the "Server Access Management" tab
3) Click on the "Administrative Roles" tab; note that there is no way to select discrete privileges outside the defined sets (e.g., allow replication privileges without also allowing SUPER)
4) Click on the "Schema Privileges" tab; note that you only have a limited set of privileges, and they can only be applied at the schema (database) level

Suggested fix:
Add the missing functionality to the Workbench. Without the functionality to manage all aspects of user privilege status, the Workbench cannot be considered a complete replacement for the end-of-life GUI Tools package.

Bug #57853 was marked as a duplicate of this one.

Bug #66381 was marked as duplicated of this one.

I just wanted to point out that although this feature request is marked for Windows, it is missing from OS X as well.

Duplicate of bug #61066