ACL_CONNECT patch 6
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}
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.
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