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:	Won't Fix	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

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.