| From: | Guillaume Perréal <perreal(at)lyon(dot)cemagref(dot)fr> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Bug with groups and access permissions (7.0.0RC1) |
| Date: | 2000-05-24 08:37:26 |
| Message-ID: | 392B94C6.A90B2BB6@lyon.cemagref.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello.
It seems there is a 'referential integrity' bug with groups and permissions:
db=> CREATE USER user1;
CREATE USER
db=> CREATE GROUP group1 WITH SYSID 4 USER user1;
CREATE GROUP
db=> CREATE TABLE table1 (field1 integer PRIMARY KEY);
CREATE
db=> REVOKE ALL ON table1 FROM PUBLIC;
CHANGE
db=> GRANT ALL ON table1 TO GROUP group1;
CHANGE
db=> DROP GROUP group1;
DROP GROUP
\z
NOTICE: get_groname: group 4 not found
The connection to the server was lost. Attempting reset: Failed.
!=>
Later...
db=> DROP USER userx;
ERROR: group groupy does not exist.
db=> SELECT * from PG_GROUP;
...
groupy | 5 | {1,4}
...
db=> DROP GROUP groupy;
DROP
Just one question: what's that???
Thanks.
--
Guillaume Perréal - Stagiaire MIAG
Cemagref (URH), Lyon, France
Tél: (+33) 4.72.20.87.64
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephane Bortzmeyer | 2000-05-24 08:51:52 | Re: Timezones on Tru64 (Digital Unix) |
| Previous Message | Louis-David Mitterrand | 2000-05-24 07:21:02 | arguments passed to a trigger function |