public inbox for [email protected]  
help / color / mirror / Atom feed
From: David G. Johnston <[email protected]>
To: Maxime Legault-Venne <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Default session role broken in PostgreSQL 14.14?
Date: Mon, 18 Nov 2024 14:27:29 -0700
Message-ID: <CAKFQuwYJKSbViv=5JJ-3Orko7h=xnAjqiOGeroQn0xhuyW_SxA@mail.gmail.com> (raw)
In-Reply-To: <DM6PR08MB4203384F44E9680BFDCC34A0FE272@DM6PR08MB4203.namprd08.prod.outlook.com>
References: <DM6PR08MB4203384F44E9680BFDCC34A0FE272@DM6PR08MB4203.namprd08.prod.outlook.com>

On Mon, Nov 18, 2024 at 2:24 PM Maxime Legault-Venne <
[email protected]> 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/[email protected]...

David J.


view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Default session role broken in PostgreSQL 14.14?
  In-Reply-To: <CAKFQuwYJKSbViv=5JJ-3Orko7h=xnAjqiOGeroQn0xhuyW_SxA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox