MySQL Bugs: #79764: "The account you are currently using does not have sufficient privileges"

Bug #79764	"The account you are currently using does not have sufficient privileges"
Submitted:	23 Dec 2015 12:49	Modified:	24 Dec 2015 6:00
Reporter:	Claudio Nanni	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	6.3, 6.3.6	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	privileges, users, workbench

Description:
GRANT SUPER, CREATE USER ON *.* TO 'jack'@'%' IDENTIFIED BY '123';
GRANT ALL PRIVILEGES ON `jackdb`.* TO 'jack'@'%' WITH GRANT OPTION;

User 'jack' can add users to operate on 'jackdb' schema:

Login as 'jack' (via any tool) and issue:

mysql> GRANT SELECT ON 'jackdb'.* to 'bill'@'%';
Query OK, 0 rows affected (0.00 sec)

Nevertheless if I click on the "Users and Privileges" tab in MySQL Workbench you see: "The account you are currently using does not have sufficient privileges".

Since 'jack' can add users to his 'jackdb' schema it should be allowed to manage users also in the "Users and Privileges" tab of MySQL Workbench.

How to repeat:
1) Create user as follow:

GRANT SUPER, CREATE USER ON *.* TO 'jack'@'%' IDENTIFIED BY '123';
GRANT ALL PRIVILEGES ON `jackdb`.* TO 'jack'@'%' WITH GRANT OPTION;

2) Login in MySQL Workbench as 'jack'

3) Click on "Users and Privileges"

Suggested fix:
Allow a user to manage "Users and Privileges" if he has the privileges to do so.

Hello Claudio Nanni,

Thank you for the report.

Thanks,
Umesh