MySQL Bugs: #89865: errors enabling permissions for awsauthenticationplugin users

Bug #89865	errors enabling permissions for awsauthenticationplugin users
Submitted:	1 Mar 2018 10:08	Modified:	9 Mar 2018 7:43
Reporter:	jonathan reiter	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.10	OS:	MacOS (macOS 10.13.x High Sierra x86_64)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
I have a user set up with awsauthenticationplugin.  when I log in as a regular authentication admin user and look under "administration - users and privileges" in the login panel this is shown correctly for the was user.

if I change to the "administrative roles" or "schema privileges" panels, click to enable a permission, and click apply I get "unhandled exception: awsauthentication plugin" in a popup.

I now need to restart.  after that if I log in again and run:
grant insert,update,delete,execute on some_table to user_name
I see these permissions correctly reflected in the "users and privileges" panel.

I can work around this by typing in the enable commands.  that kind of defeats the point of having these panels.

How to repeat:
instructions to repeat are in the description.

Suggested fix:
doesn't the panel just wrap some "grant ..." commands?  I am logged in as an admin user and those commands work fine when executed in the regular-old sql box.  I do not understand why the authentication type of the account I'm permissioning matters at all.  I expect the account I'm logged-in as to matter -- and again that is a regular username/password user with lots of admin rights.

Hello jonathan,

Thank you for the bug report.
Verified based on internal discussion with dev's.

Thanks,
Chiranjeevi.