Re: [keycloak-user] Users assigned to roles

From: "Alarik Myrin" <alarik(a)zwift.com&gt; To: keycloak-user(a)lists.jboss.org Sent: Tuesday, November 18, 2014 6:37:31 PM Subject: Re: [keycloak-user] Users assigned to roles I was able to piece together a SQL query: SELECT u.username, u.first_name, u.last_name, role.name AS role FROM keycloak_role role INNER JOIN realm ON role.realm = realm.id INNER JOIN user_role_mapping rm ON role.id = rm.role_id INNER JOIN user_entity u ON rm.user_id = u.id WHERE realm.name =:1 AND role.name = :2 It might be nice to do this in the web console though...

On Tue, Nov 18, 2014 at 12:28 PM, Alarik Myrin < alarik(a)zwift.com > wrote: Is there any easy way to see which users have been assigned a given role? _______________________________________________ keycloak-user mailing list keycloak-user(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user