Find all users with certain role

I need to be able to generate a list of users that have been granted a certain role. I'm running MariaDB: 10.1.29

Thanks in advance.

Answer Answered by Isaac Geller in this comment.

That table doesn't seem to exist in my version of the DB. However, I did find mysql.roles_maping table and got what I need using

select * from roles_mapping where role = '<myrole>';


Comments loading...
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.