[keycloak-user] Users assigned to roles

[Alarik Myrin]

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 at zwift.com> wrote:

> Is there any easy way to see which users have been assigned a given role?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20141118/f64c1620/attachment.html