After upgrading to version 14.14, the behavior of roles related to the "set role" option broke.
We actively use the feature "alter user <username> set role db_role"
in order to automatically change the role context upon login.
If this was an abnormal behavior, is there an alternative way to automatically change the role context when connecting to the DB?
We actively use the feature "alter user <username> set role db_role"
in order to automatically change the role context upon login.
But now this behavior has changed, and the context does not change, which unfortunately breaks all role-based access to data.
If this was an abnormal behavior, is there an alternative way to automatically change the role context when connecting to the DB?