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

[23 Dec 2015 12:49] Claudio Nanni
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.
[24 Dec 2015 6:00] Umesh Shastry
Hello Claudio Nanni,

Thank you for the report.

Thanks,
Umesh