Env. 19c SE
When setting roles and checking if they are set in a user session, not all roles that the user has been granted are returned.
Does setting a role as default have any impact?
set role all except connect, resource, soda_app, hs_admin_select_role;
select * from session_roles;