steampipe plugin install theapsgroup/keycloak

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_name
from
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_role
where
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_name
from
keycloak_client c
left join keycloak_client_role cr on c.id = cr.client_id
where
c.client_id = 'my-client';

Schema for keycloak_client_role

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
client_idtext=Unique identifier for the client
compositebooleanIndicates if the client role is a composite role (multiple combined roles)
descriptiontextDescription given to the client role
idtextUnique identifier for the client role
nametextName of the client role