[keycloak-user] Users assigned to roles

[Stian Thorgersen]

----- Original Message -----
> From: "Alarik Myrin" <alarik at zwift.com>
> To: keycloak-user at 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...

Yep, please JIRA

> 
> 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?
> 
> 
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user