Table: keycloak_client_role
Obtaining client roles for clients in the Keycloak realm, however you must specify a client_id
(this is id
in the keycloak_client
table) in there where or join clause
Examples
List all client roles for every client
select c.client_id client, c.name, cr.name role_namefrom keycloak_client c left join keycloak_client_role cr on c.id = cr.client_id;
List client roles for a single client by unique id
select *from keycloak_client_rolewhere client_id = '53a020bf-8ddf-4f24-9f66-c7310e116f97'
List client roles for a single client by friendly id
select c.client_id client, c.name, cr.name role_namefrom keycloak_client c left join keycloak_client_role cr on c.id = cr.client_idwhere c.client_id = 'my-client';
Schema for keycloak_client_role
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
client_id | text | = | Unique identifier for the client |
composite | boolean | Indicates if the client role is a composite role (multiple combined roles) | |
description | text | Description given to the client role | |
id | text | Unique identifier for the client role | |
name | text | Name of the client role |