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 ...  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: DROP GROUP leaves permissions a mess ...  (Stephen Frost <sfrost@snowman.net>)
Список 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 по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: More buildfarm stuff
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: More buildfarm stuff