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

2012-01-14 Thread Noah Misch
On Sat, Jan 14, 2012 at 06:34:25PM +0200, Heikki Linnakangas wrote: > On 02.01.2012 21:46, Noah Misch wrote: >> On Fri, Oct 28, 2011 at 11:42:38AM -0400, Noah Misch wrote: >>> On Fri, Oct 28, 2011 at 09:32:30AM -0400, Robert Haas wrote: On Thu, Oct 27, 2011 at 6:15 PM, Tom Lane wrote: > N

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

2012-01-14 Thread Heikki Linnakangas
On 02.01.2012 21:46, Noah Misch wrote: On Fri, Oct 28, 2011 at 11:42:38AM -0400, Noah Misch wrote: On Fri, Oct 28, 2011 at 09:32:30AM -0400, Robert Haas wrote: On Thu, Oct 27, 2011 at 6:15 PM, Tom Lane wrote: Noah Misch writes: Let's look at the behavior of DDL-exposed access constraints fo

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

2012-01-02 Thread Noah Misch
On Fri, Oct 28, 2011 at 11:42:38AM -0400, Noah Misch wrote: > On Fri, Oct 28, 2011 at 09:32:30AM -0400, Robert Haas wrote: > > On Thu, Oct 27, 2011 at 6:15 PM, Tom Lane wrote: > > > Noah Misch writes: > > >> Let's look at the behavior of DDL-exposed access constraints for > > >> precedent. ?We >

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

2011-10-28 Thread Noah Misch
On Fri, Oct 28, 2011 at 09:32:30AM -0400, Robert Haas wrote: > On Thu, Oct 27, 2011 at 6:15 PM, Tom Lane wrote: > > Noah Misch writes: > >> Let's look at the behavior of DDL-exposed access constraints for > >> precedent. ?We > >> currently have three paradigms for applying access control to supe

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

2011-10-28 Thread Tom Lane
Robert Haas writes: > On Thu, Oct 27, 2011 at 6:15 PM, Tom Lane wrote: >> Noah Misch writes: >>> I think we should merge #3 into #2; nothing about the REPLICATION setting >>> justifies a distinct paradigm. >> Yeah, there's much to be said for that. I thought the notion of a >> privilege that s

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

2011-10-28 Thread Robert Haas
On Thu, Oct 27, 2011 at 6:15 PM, Tom Lane wrote: > Noah Misch writes: >> Let's look at the behavior of DDL-exposed access constraints for precedent.   >> We >> currently have three paradigms for applying access control to superusers: > >> 1. Settings that affect superusers and regular users ident

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

2011-10-27 Thread Tom Lane
Noah Misch writes: > Let's look at the behavior of DDL-exposed access constraints for precedent. > We > currently have three paradigms for applying access control to superusers: > 1. Settings that affect superusers and regular users identically. These > include > ALTER ROLE ... LOGIN | VALID

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

2011-10-27 Thread Noah Misch
On Thu, Oct 27, 2011 at 01:45:34PM -0400, Robert Haas wrote: > 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 N