Bug #49071 Revert on adding admin roles makes user disappear
Submitted: 24 Nov 2009 20:57 Modified: 27 Nov 2009 11:25
Reporter: Todd Farmer (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2 r4753 OS:Windows (XP)
Assigned to: Alfredo Kojima CPU Architecture:Any

[24 Nov 2009 20:57] Todd Farmer 
Description:
When working with user accounts in WB, I selected the (previously-unchecked) DBA role.  That added grants I didn't want, so I tried unchecking the DBA role (this pulled all grants out, rather than just the ones which were added).  I decided to use the "revert" button, instead, and it deleted the user account from the left-hand picklist.  It doesn't appear to have dropped the user, but makes for a bad experience.

How to repeat:
See above.

Suggested fix:
Don't remove user from the picklist.
[25 Nov 2009 19:24] Johannes Taxacher 
switching to another tab and back reloads the user list (which shows that the user hasn't been dropped). as a workaround
[27 Nov 2009 8:55] Johannes Taxacher 
fixed in repository. fix will be included in 5.2.10
[27 Nov 2009 11:25] Tony Bedford 
An entry has been added to the 5.2.10 changelog:

In the Administrative Roles tab of Server Access Management, selection of Roles did not work correctly. For example, selecting the DBA checkbox, and then deselecting it, caused all roles to be deselected. Further, using the Revert button resulted in the selected user disappearing from the User Accounts panel.