MySQL Bugs: #88752: Invalid error message on schema privilege alteration operation

Bug #88752	Invalid error message on schema privilege alteration operation
Submitted:	5 Dec 2017 3:26	Modified:	15 Mar 2018 13:22
Reporter:	Glen McAllister	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	6.3.10	OS:	MacOS (10.12.6)
Assigned to:		CPU Architecture:	Any
Tags:	privileges, schema, user, workbench

Description:
Attempting to GRANT a schema level privilege by a privileged user in one database results in an error message relating to an inability to REVOKE privileges in another database; e.g. when trying to add trigger privilege on <db1>.* for <user> I get the following message:

“uError revoking privileges for <user> in schema <db2>. You must have the GRANT OPTION privilege and you must have the privileges that you are revoking”

The user attempting the GRANT has the GRANT OPTION privilege (I get this as both root and non-root user)

The user can perform the grant in the SQL editor with this connection. The user is not attempting to REVOKE in schema <db2>, they are attempting to GRANT in schema <db1>. However, this same error is encountered when removing/revoking a privilege; i.e. Workbench complaining about REVOKE privileges in ANOTHER database.

This error is also encountered in the Windows version of Workbench.

MySQL version 5.6.38 on Mac OS X 10.11.6.

How to repeat:
Connect to database server as privileged user
Select Users and Privileges
Select user to alter
Select Schema Privileges tab
Select schema
Select schema-level privilege to add not already selected/granted; e.g. TRIGGER

Thank you for the bug report. Please provide a screen-shot which illustrate the issue? (use Files tab for). Thanks.

Screenshot of error message when trying to add SHOW VIEW privilege for schema

Attachment: MySQLWorkbench bug 20171207.pdf (application/pdf, text), 2.07 MiB.

2nd Screenshot of error message when trying to add SHOW VIEW privilege for schema

Attachment: MySQLWorkbench bug 20171207.tiff (image/tiff, text), 341.19 KiB.

Hi - screenshot(s) uploaded. Same screenshot - different formats. Didn’t know if .pdf was ok or not.

Hello Glen,

Thank you for the feedback.
I could not repeat the issue at our end using with MySQL workbench 6.3.10 version with MySQL 5.7.21 and 5.6.39 versions.
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.