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.
Just to note, all this is being done with root user. If i issue the research role to root user then it can execute SHOW GRANTS FOR research. I assumed ROOT should be able to see the grants because it has rights for grants?
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 researchbefore the
SHOWmakes 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