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>';