ACL_CONNECT patch 6

Started by Gevik Babakhaniover 19 years ago2 messages
#1Gevik Babakhani
pgdev@xs4all.nl

I have changed the revoke part of the patch. This time no restrictions,
only a warning message about a possible lockout.

http://www.xs4all.nl/~gevik/patch/patch-0.6.diff

Tom, Alvaro,

Do you think this will be accepted?

----------------------------------------------------------------------

[gevik@voyager ~]$ createdb
CREATE DATABASE
[gevik@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=# select datname,datacl from pg_catalog.pg_database;
datname | datacl
-----------+----------------------------
postgres |
gevik |
template1 | {=c/gevik,gevik=CTc/gevik}
template0 | {=c/gevik,gevik=CTc/gevik}
(4 rows)

gevik=# revoke connection on database gevik from public;
REVOKE
gevik=# revoke connection on database gevik from gevik;
WARNING: This revoke statement removes the last database connection
privilege from database gevik.
DETAIL: Unless you have superuser privileges you could be locked out
from connecting to this database.
REVOKE
gevik=# select datname,datacl from pg_catalog.pg_database;
datname | datacl
-----------+----------------------------
postgres |
template1 | {=c/gevik,gevik=CTc/gevik}
template0 | {=c/gevik,gevik=CTc/gevik}
gevik | {=T/gevik,gevik=CT/gevik}

#2Alvaro Herrera
alvherre@commandprompt.com
In reply to: Gevik Babakhani (#1)
Re: ACL_CONNECT p.tch 6

Resend: my ISP reinstalled a stupid filter in their SMTP server.

Gevik Babakhani wrote:

I have changed the revoke part of the patch. This time no restrictions,
only a warning message about a possible lockout.

http://www.xs4all.nl/~gevik/patch/patch-0.6.diff

Nah, after seeing Tom's comments it's clear that not even the warning is
needed. I think patch 4 was OK already, not sure.

Do you think this will be accepted?

Certainly.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support