Broken behavior after minor update CVE-2024-10978 - Mailing list pgsql-admin

From Антон Глушаков
Subject Broken behavior after minor update CVE-2024-10978
Date
Msg-id CAHnOmac-kzCxxm8OKa31FDJiyHRLgwbcs555_-HdeqhRJ6mEow@mail.gmail.com
Whole thread Raw
Responses Re: Broken behavior after minor update CVE-2024-10978
List pgsql-admin
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.
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?

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: RDS restore failed due to WAL log and disk space-- any tidy fixes?
Next
From: Motog Plus
Date:
Subject: Guidance Needed for PostgreSQL Upgrade from 12 to 15