From: Nathan Bossart <nathandbossart@gmail.com>
To: kolpasch@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18717: ALTER ROLE SET ROLE functionality is broken
Date: Wed, 20 Nov 2024 09:48:27 -0600
Message-ID: <Zz4Ey8mMhbyl8oJq@nathan> (raw)
In-Reply-To: <18717-6cddff21930a88e6@postgresql.org>
References: <18717-6cddff21930a88e6@postgresql.org>
On Wed, Nov 20, 2024 at 12:33:41PM +0000, PG Bug reporting form wrote:
> We grant the owner role to the login roles, and assign it by ALTER ROLE
> <login_role> SET ROLE = <owner_role>. As a result, when logging into the
> database with a login role, it is automatically assigned the owner role.
>
> Starting with version 14.14, this behavior is broken, and the issue persists
> in version 17.1. When connecting to the database with a login role, the
> session is assigned an empty (none) value for the role, leaving users
> without the necessary permissions.
This should be fixed in the next set of minor versions scheduled for
release tomorrow [0].
[0] https://postgr.es/c/7b88529
--
nathan
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: pgsql-bugs@postgresql.org
Cc: nathandbossart@gmail.com, kolpasch@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18717: ALTER ROLE SET ROLE functionality is broken
In-Reply-To: <Zz4Ey8mMhbyl8oJq@nathan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox