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