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

From David G. Johnston
Subject Re: User with BYPASSRLS privilege can't change password
Date
Msg-id CAKFQuwYvEFPRGXv2tbV-2ymsUA+2gTULCab5QH_sm23W8ODW2w@mail.gmail.com
Whole thread Raw
In response to Re: User with BYPASSRLS privilege can't change password  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Tue, Nov 3, 2020 at 12:06 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> Is the nuance that in reality a non-superuser cannot specify BypassRLS even
> if the effective value is unchanged unimportant here?

I was wondering about that.  You could definitely make a case for a
weaker set of rules here.  However, the superuser restriction has been
like that for 15-ish years without much complaint, so it doesn't seem
that it bothers people in practice.


Agreed that the behavior seems fine to keep.  Was more about the documentation saying "change" instead of "specify".

David J.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: User with BYPASSRLS privilege can't change password
Next
From: Wolfgang Walther
Date:
Subject: Re: Calling variadic function with default value in named notation