Date: Wed, 20 Nov 2024 09:48:27 -0600
From: Nathan Bossart <nathandbossart@gmail.com>
To: kolpasch@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18717: ALTER ROLE SET ROLE functionality is broken
Message-ID: <Zz4Ey8mMhbyl8oJq@nathan>
References: <18717-6cddff21930a88e6@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <18717-6cddff21930a88e6@postgresql.org>
Archived-At: <https://www.postgresql.org/message-id/Zz4Ey8mMhbyl8oJq%40nathan>
Precedence: bulk

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