Skip site navigation (1) Skip section navigation (2)

Re: Streaming replication as a separate permissions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Florian Pflug <fgp(at)phlo(dot)org>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Streaming replication as a separate permissions
Date: 2010-12-24 04:00:14
Message-ID: 3475.1293163214@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Florian Pflug <fgp(at)phlo(dot)org> writes:
> The problem here is that you suggest NOLOGIN should mean "Not allowed
> to issue SQL commands", which really isn't what the name "NOLOGIN"
> conveys.

No, it means "not allowed to connect".  It's possible now to issue
commands as a NOLOGIN user, you just have to use SET ROLE to become the
user.  I think you're arguing about a design choice that was already
made some time ago.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2010-12-24 04:31:38
Subject: Re: Streaming replication as a separate permissions
Previous:From: Florian PflugDate: 2010-12-24 03:41:27
Subject: Re: proposal : cross-column stats

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group