Table: keycloak_user
Obtaining basic user information from the Keycloak realm.
Examples
List all users
select *from keycloak_user;
Get a specific user by id
select *from keycloak_userwhere id = 'a1399321-d1a5-4e00-9034-eb8046d6a9dc';
Get a specific user by username
select *from keycloak_userwhere username = 'testuser';
Get a specific user by email address
select *from keycloak_userwhere email = 'testuser@example.com';
List disabled user accounts
select *from keycloak_userwhere enabled = false;
Schema for keycloak_user
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
created_timestamp | timestamp with time zone | Timestamp of user creation | |
text | = | Email address of the user | |
email_verified | boolean | Indicates if the user has verified their email address | |
enabled | boolean | = | Indicates if the user is enabled |
first_name | text | = | First name of the user |
id | text | = | Unique identifier for the user |
last_name | text | = | Last name of the user |
username | text | = | Login/Username of the user |