Re: TODO Item: ACL_CONNECT - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: TODO Item: ACL_CONNECT
Date
Msg-id 20060425125315.GE24421@surnet.cl
Whole thread Raw
In response to Re: TODO Item: ACL_CONNECT  (Gevik Babakhani <pgdev@xs4all.nl>)
Responses Re: TODO Item: ACL_CONNECT
List pgsql-hackers
Gevik Babakhani wrote:
> Hi 
> 
> On Mon, 2006-04-24 at 23:07 -0400, Alvaro Herrera wrote:
> > Gevik Babakhani wrote:
> > 
> > > If one is going to revoke the last ACL_CONNECT, a warning is going to
> > > issued then that part of the REVOKE gets canceled.
> > 
> > Humm, no, the WARNING is issued but the REVOKE is executed anyway.
> 
> I have tested this by applying the patch-0.4.diff of a new src tree.

My point is that the behavior you describe is broken.  The warning
should be issued but the command should be executed anyway.  That way
the user executing it knows that he has locked everyone out of the
database (but he can lock everyone out of the database if he wants to.)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: TODO Item: ACL_CONNECT
Next
From: Stephen Frost
Date:
Subject: Re: TODO Item: ACL_CONNECT