Re: BUG #15281: Set role does not affect superuser privleges - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15281: Set role does not affect superuser privleges
Date
Msg-id 9786.1531779170@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #15281: Set role does not affect superuser privleges  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: BUG #15281: Set role does not affect superuser privleges
List pgsql-bugs
Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> On 07/16/2018 04:55 PM, PG Bug reporting form wrote:
>> Here are the two scenarios I tested:
>> 1) as a session_user: superuser and current_user: non-superuser I can edit
>> others' tables
>> 2) as a session_user: non-superuser and current_user: superuser I cannot
>> edit others' tables

> It's usually a good idea to provide exact scripts / output so that
> people can reproduce the issue easily. For me it behaves like this:
> ...
> So, correct in both cases. I'm not on Windows, but I don't see why would
> it behave differently there.

Tomas' test left out the "GRANT user0 to user1" bit, but I can't
reproduce the behavior as described either.

            regards, tom lane


pgsql-bugs by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: BUG #15281: Set role does not affect superuser privleges
Next
From: Tomas Vondra
Date:
Subject: Re: BUG #15281: Set role does not affect superuser privleges