Re: BUG #6264: Superuser does not have inherent Replication permission

On Tue, Oct 25, 2011 at 1:39 PM, Magnus Hagander <magnus@hagander.net> wrot=
e:
> On Mon, Oct 24, 2011 at 16:37, Keith Fiske <keith@omniti.com> wrote:
>> On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> "Keith Fiske" <keith@omniti.com> writes:
>>
>>>> If you create a user as a NONsuperuser,
>>>> then later ALTER them to be one, they will NOT have the replication
>>>> permission and cannot be used as a replication user until you explicit=
ly
>>>> grant that permission.
>>>
>>> That doesn't sound to me like a bug. =A0These flags are independent, we
>>> just provide a certain default at role creation time.
>>>
>>
>> That is not what the documentation as read would lead people to
>> believe. I'd be more than happy to help with clarifying the
>> documentation myself if needed. Just let me know how.
>
> This part I agree with - it makes sense for ALTER to set both flags
> when it enables superuser.

+1

Change the behaviour to match the docs makes most sense to me.


--=20
=A0Simon Riggs=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 http:/=
/www.2ndQuadrant.com/
=A0PostgreSQL Development, 24x7 Support, Training & Services