Re: Streaming replication as a separate permissions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Streaming replication as a separate permissions
Date
Msg-id 27452.1293136261@sss.pgh.pa.us
Whole thread Raw
In response to Re: Streaming replication as a separate permissions  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
> On Thu, Dec 23, 2010 at 16:15, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I think only superusers should be allowed to change the flag.

> That was certainly not intentional - and doesn't work that way for me
> at least, unless I broke it right before I submitted it.

> oh hang on.. Yeah, it's allowing anybody *that has CREATE ROLE*
> privilege to do it, I think. And I agree that's wrong and should be
> fixed. But I can't see it allowing anybody at all to do it - am I
> misreading the code?

Ah, sorry, yeah there are probably CREATE ROLE privilege checks
somewhere upstream of here.  I was expecting to see a privilege check
added by the patch itself, and did not, so I complained.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Li Jie"
Date:
Subject: Re: Why is sorting on two columns so slower than sortingon one column?
Next
From: Pavel Stehule
Date:
Subject: WIP: plpgsql - foreach in