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