Comments - SHOW GRANTS
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I can't recreate, as when I do the same workflow on 10.1.8 Ubuntu, I can see the grants. I ran the following statements, taken from your code above, with fixed syntax.
Doing the same with
SET ROLE research
before theSHOW
makes no difference.I suggest reporting this as a bug, as perhaps someone can find an environment where this fails, or find the problem in your situation.
Thanks for the feedback @greenman
Very well, I shall do as you advise.
Please note that
1) I am also unable to reproduce on Windows 7 as per the snaggy below it works as expected http://snag.gy/9d5PA.jpg
2) However, I have reproduced it in Ubuntu 14.04. Apologies there is some earlier confusion above, the initial try was on Centos 6.7 (see link below) http://snag.gy/872B4.jpg