Re: User with BYPASSRLS privilege can't change password

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wolfgang Walther <walther(at)technowledgy(dot)de>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: User with BYPASSRLS privilege can't change password
Date: 2020-11-03 16:22:59
Message-ID: 923005.1604420579@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Wolfgang Walther <walther(at)technowledgy(dot)de> writes:
> CREATE USER bob BYPASSRLS;
> SET ROLE bob;
> ALTER USER bob PASSWORD 'x';
> -- ERROR: must be superuser to change bypassrls attribute

Yeah, duplicated here on HEAD. The error message seems to think
the command is trying to remove the BYPASSRLS privilege, which
suggests somebody forgot to copy that flag somewhere where it needs
to be copied. Haven't dug further than that.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-11-03 16:52:06 Re: segfault with incremental sort
Previous Message Tom Lane 2020-11-03 16:19:04 Re: pg should ignore u+200b zero width space