DROP GROUP leaves permissions a mess ...
| От | Marc G. Fournier |
|---|---|
| Тема | DROP GROUP leaves permissions a mess ... |
| Дата | |
| Msg-id | 20050725185658.C54567@svr1.postgresql.org обсуждение исходный текст |
| Ответы |
Re: DROP GROUP leaves permissions a mess ...
Re: DROP GROUP leaves permissions a mess ... |
| Список | pgsql-hackers |
Using an 8.0.3 database, if I do:
CREATE GROUP testgrp WITH USER pgsql;
GRANT ALL ON timezone TO GROUP testgrp;
DROP GROUP testgrp;
The table permissions still contain the reference to the 'group':
public | timezone | table | {pgsql=arwdRxt/pgsql,"group 100=arwdRxt/pgsql"}
And you can't REVOKE those permissions afterwards:
ams=# REVOKE ALL ON timezone FROM GROUP testgrp;
ERROR: group "testgrp" does not exist
ams=# REVOKE ALL ON timezone FROM GROUP "100";
ERROR: group "100" does not exist
Should there not be an ERROR returned when you try and drop a user/group
that has permissions on a table in the database, to prevent this?
В списке pgsql-hackers по дате отправления: