MySQL Bugs: #69660: User administration: unable to remove schema privileges

Bug #69660	User administration: unable to remove schema privileges
Submitted:	3 Jul 2013 12:01	Modified:	27 Jul 2013 19:58
Reporter:	Van Stokes	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S2 (Serious)
Version:	6.0.2.10924	OS:	Any (Ubuntu 12.04 x86_64)
Assigned to:		CPU Architecture:	Any
Tags:	Administration, privileges, schema, users, workbench

Description:
MySQL Server: 5.5.31-ubuntu amd64
MySQL Server OS: Ubuntu 12.04 LTS amd64
Workbench: 6.0.2.10924
Workbench OS: Ubuntu 13.04 amd64

Problem:
Workbench does not REMOVE a users Schema Privileges (in Schema Privileges tab).

How to repeat:
01. Start WB
02. Click Management -> Users and Privileges (left menu)
03. Click Administration - Users and Privileges (tab) -> Schema Privileges (tab)
04. Select a user from Users list
05. Select one or more schema privileges
06. Click the Delete Entry button
07. Click the Save Changes button
08. Goto a query tab and do a FLUSH PRIVILEGES
09. Exit WB
10. Restart WB
11. Click Management -> Users and Privileges (left menu)
12. Click Administration - Users and Privileges (tab) -> Schema Privileges (tab)
13. Select a user from Users list

You will not that the schema privileges are still present.

Suggested fix:
Review code and correct.

Thank you for the bug report. What you mean with:

"You will not that the schema privileges are still present."

Following your how to repeat: 1-13 steps on CentOS 6.4 The schema privileges added step 5, deleted step 6 aren't present which I assume is correct when followed the 07-13 steps.

Argh!

That was suppose to say:

"You will NOTICE that the schema privileges are still present."

I did not include adding privileges in my steps. My steps assume that the user has one or more schema privileges assigned.

The issue is WB will add/modify user schema privileges but will not delete them.

Thank you for the feedback.

Fixed as of the upcoming MySQL Workbench 6.0.4 release, and here's the changelog entry:

The "Schema Privileges" tab would not remove a user's schema privileges
after pressing "Delete". Only the "Add" and "Modify" operations
functioned.

Thank you for the bug report.