User with BYPASSRLS privilege can't change password - Mailing list pgsql-bugs

From Wolfgang Walther
Subject User with BYPASSRLS privilege can't change password
Date
Msg-id a5548a9f-89ee-3167-129d-162b5985fcf8@technowledgy.de
Whole thread Raw
Responses Re: User with BYPASSRLS privilege can't change password
List pgsql-bugs
Hi,

observed on PG12.4:

CREATE USER alice;
SET ROLE alice;
ALTER USER alice PASSOWRD 'x';
-- works

RESET ROLE;

CREATE USER bob BYPASSRLS;
SET ROLE bob;
ALTER USER bob PASSWORD 'x';
-- ERROR: must be superuser to change bypassrls attribute

I would expect bob to be able to change his password here.

Best

Wolfgang



pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: pg should ignore u+200b zero width space
Next
From: Tom Lane
Date:
Subject: Re: pg should ignore u+200b zero width space