From: | Gevik Babakhani <pgdev(at)xs4all(dot)nl> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: TODO Item: ACL_CONNECT |
Date: | 2006-04-25 08:12:35 |
Message-ID: | 1145952755.31215.14.camel@voyager.truesoftware.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
[gevik(at)voyager ~]$ createdb
CREATE DATABASE
[gevik(at)voyager ~]$ psql
Welcome to psql 8.2devel, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
gevik=# revoke connection on database gevik from gevik;
REVOKE
gevik=# revoke connection on database gevik from public;
WARNING: The revoke statement or at least one part of it cannot be
completed on database gevik
DETAIL: At least one database connection privilege should be granted
for this database
REVOKE
gevik=# select datname,datacl from pg_catalog.pg_database;
datname | datacl
-----------+----------------------------
postgres |
gevik | {=Tc/gevik,gevik=CT/gevik}
template1 | {=c/gevik,gevik=CTc/gevik}
template0 | {=c/gevik,gevik=CTc/gevik}
(4 rows)
gevik=#
From | Date | Subject | |
---|---|---|---|
Next Message | Gevik Babakhani | 2006-04-25 08:15:55 | Re: TODO Item: ACL_CONNECT |
Previous Message | Tom Lane | 2006-04-25 07:18:06 | Re: [GENERAL] Concurrency problem building indexes |