Re:“Codeless” backend using PostgreSQL, PostgREST and Keycloak
by runeks on Thursday February 04, 2021 @04:51AM
(#26024108)
Regarding the "users" table: how are users registered with Keycloak saved to the app DB? I assume this is necessary if I want to use Postgres row-level security. Is Keycloak set up to store newly created users in the app DB?
The article mentions a PostgREST endpoint "/rpc/add_user_if_not_exists". Do I need to set up Keycloak to perform a POST request on this endpoint upon a new user registering via Keycloak?
Or can this be done for all requests by simply executing "api.add_user_if_not_exists()" before all other queries, hereby assuming that whatever is in "request.jwt.claim.sub" has been verified by Keycloak?
Re:“Codeless” backend using PostgreSQL, PostgREST and Keycloak
by mathieupassenau on Friday February 05, 2021 @08:12AM
(#26035911)
Hi,
In this case, we use this procedure from the frontend app. When a user registers on Keycloak, this user is only stored on Keycloak.
Keycloak is used as an authentication provider, a "login with". The user is registered in the app on first use, even if the account already exists in Keycloak.
so, calling "api.add_user_if_not_exists" can be used on every request, only the first has an effect.
The field request.jwt.claim.sub is called "subject", this is a unique identifier for the user (a GUID with Keycloak). This field is provisionned by Keycloak, the JWT token has been verified by Postgrest with all informations (Keys).
The article mentions a PostgREST endpoint "/rpc/add_user_if_not_exists". Do I need to set up Keycloak to perform a POST request on this endpoint upon a new user registering via Keycloak?
Or can this be done for all requests by simply executing "api.add_user_if_not_exists()" before all other queries, hereby assuming that whatever is in "request.jwt.claim.sub" has been verified by Keycloak?
In this case, we use this procedure from the frontend app. When a user registers on Keycloak, this user is only stored on Keycloak.
Keycloak is used as an authentication provider, a "login with". The user is registered in the app on first use, even if the account already exists in Keycloak.
so, calling "api.add_user_if_not_exists" can be used on every request, only the first has an effect.
The field request.jwt.claim.sub is called "subject", this is a unique identifier for the user (a GUID with Keycloak). This field is provisionned by Keycloak, the JWT token has been verified by Postgrest with all informations (Keys).