steampipe plugin install theapsgroup/keycloaksteampipe plugin install theapsgroup/keycloak

keycloak_client keycloak_client_role keycloak_event keycloak_group keycloak_group_member keycloak_idp keycloak_user keycloak_user_group

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

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