| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Maxime Legault-Venne <m(dot)legault-venne(at)metrio(dot)net> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Default session role broken in PostgreSQL 14.14? |
| Date: | 2024-11-18 21:27:29 |
| Message-ID: | CAKFQuwYJKSbViv=5JJ-3Orko7h=xnAjqiOGeroQn0xhuyW_SxA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Nov 18, 2024 at 2:24 PM Maxime Legault-Venne <
m(dot)legault-venne(at)metrio(dot)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.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jian he | 2024-11-19 06:16:52 | Re: Emitting JSON to file using COPY TO |
| Previous Message | Maxime Legault-Venne | 2024-11-18 21:24:04 | Default session role broken in PostgreSQL 14.14? |