Hi,
I can't revoke things from 'public'. Do I misunderstand
something or is there a bug?:
henkvl=# create table pipo (field text);
CREATE
henkvl=# grant all on pipo to henkvl;
CHANGE
henkvl=# grant all on pipo to jack;
CHANGE
henkvl=# \z pipo
Access permissions for database "henkvl"
Relation | Access permissions
----------+-------------------------------------------------
pipo | {"=","postgres=arwR","henkvl=arwR","jack=arwR"}
(1 row)
henkvl=# revoke all on pipo from public;
CHANGE
henkvl=# \z pipo
Access permissions for database "henkvl"
Relation | Access permissions
----------+-------------------------------------------------
pipo | {"=","postgres=arwR","henkvl=arwR","jack=arwR"}
(1 row)
If I revoke from individual users there are no probs.
atlas:/root-# rpm -qf `which postgres`
postgresql-server-7.1.2-4PGDG
atlas:/root-# rpm -qf `which psql`
postgresql-7.1.2-4PGDG
Searching in the archives I found that Tom Lane fixed a prob like this
one year ago? But 7.1.2 is not that old...
Regards,
--
Henk van Lingen, Systems & Network Administrator (o- -+
Dept. of Computer Science, Utrecht University. /\ |
phone: +31-30-2535278 v_/_
http://henk.vanlingen.net/ http://www.tuxtown.net/netiquette/