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

[1 Mar 2018 10:08] jonathan reiter
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.
[9 Mar 2018 7:43] Chiranjeevi Battula
Hello jonathan,

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

Thanks,
Chiranjeevi.