Postgres Pro
Downloads
Home   >   mailing lists

Re: Default session role broken in PostgreSQL 14.14? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Default session role broken in PostgreSQL 14.14?
Date
Msg-id CAKFQuwYJKSbViv=5JJ-3Orko7h=xnAjqiOGeroQn0xhuyW_SxA@mail.gmail.com
Whole thread Raw
In response to Default session role broken in PostgreSQL 14.14?  (Maxime Legault-Venne <m.legault-venne@metrio.net>)
List pgsql-general
Tree view
On Mon, Nov 18, 2024 at 2:24 PM Maxime Legault-Venne <m.legault-venne@metrio.net> wrote:


I noticed a change of behaviour since PostgreSQL 14.14 that is breaking the permissions in my application: it looks like the “ALTER ROLE <role> IN DATABASE <db> SET ROLE <session-role>” is no longer applied when <role> is connecting to the database.


Reported as a bug previously here and fixed in this week's out-of-band update.

https://www.postgresql.org/message-id/CADOZwSb0UsEr4_UTFXC5k7=fyyK8uKXekucd+-uuGjJsGBfxgw@mail.gmail.com

David J.

pgsql-general by date:

Previous
From: Maxime Legault-Venne
Date:
Subject: Default session role broken in PostgreSQL 14.14?
Next
From: 張宸瑋
Date:
Subject: Re: Re : Credcheck extension