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

2011-10-27 Thread Tom Lane
Robert Haas writes: > ... If we do decide to change the > behavior, we'd better carefully document that if you want to make > someone a superuser without giving them replication privileges (or > revoke their superuser status without revoking replication > privileges), you need to specify both ALT

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

2011-10-27 Thread Robert Haas
On Tue, Oct 25, 2011 at 8:39 AM, Magnus Hagander wrote: > On Mon, Oct 24, 2011 at 16:37, Keith Fiske wrote: >> On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane wrote: >>> "Keith Fiske" writes: >> If you create a user as a NONsuperuser, then later ALTER them to be one, they will NOT have the

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

2011-10-25 Thread Simon Riggs
On Tue, Oct 25, 2011 at 1:39 PM, Magnus Hagander wrote: > On Mon, Oct 24, 2011 at 16:37, Keith Fiske wrote: >> On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane wrote: >>> "Keith Fiske" writes: >> If you create a user as a NONsuperuser, then later ALTER them to be one, they will NOT have the

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

2011-10-25 Thread Magnus Hagander
On Mon, Oct 24, 2011 at 16:37, Keith Fiske wrote: > On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane wrote: >> "Keith Fiske" 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

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

2011-10-24 Thread Keith Fiske
On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane wrote: > "Keith Fiske" writes: >> The documentation says replication is inherent to a superuser. > > What it actually says is that superusers get the replication privilege > by default --- but you can create a superuser without that.  If you > see a plac

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

2011-10-22 Thread Tom Lane
"Keith Fiske" writes: > The documentation says replication is inherent to a superuser. What it actually says is that superusers get the replication privilege by default --- but you can create a superuser without that. If you see a place that says something different, please point it out specific

[BUGS] BUG #6264: Superuser does not have inherent Replication permission

2011-10-21 Thread Keith Fiske
The following bug has been logged online: Bug reference: 6264 Logged by: Keith Fiske Email address: ke...@omniti.com PostgreSQL version: 9.1.1 Operating system: Debian Description:Superuser does not have inherent Replication permission Details: Was testing out an up