Comments - Find all users with certain role
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.
Use the Information Schema APPLICABLE_ROLES table:
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>';