Drop user doesn't drop granted privs?

Поиск
Список
Период
Сортировка
От Pete Deffendol
Тема Drop user doesn't drop granted privs?
Дата
Msg-id a1db1de60601061455k6aa46f39oee71ddc4c9f6031b@mail.gmail.com
обсуждение исходный текст
Ответы Re: Drop user doesn't drop granted privs?  (Stephen Frost <sfrost@snowman.net>)
Re: Drop user doesn't drop granted privs?  (Jaime Casanova <systemguards@gmail.com>)
Список pgsql-general
Correct me if I'm wrong, but it seems that PostgreSQL 7.4 does not remove a user's privileges on tables when that user is dropped.  The privileges are still showing up if I do a \z in psql, but with the SYSID instead of the username (obviously, since the username doesn't exist.)  Is there an easy way to remove the privileges, either at the same time a user is dropped, or afterwards?

Pete

В списке pgsql-general по дате отправления:

Предыдущее
От: SunWuKung
Дата:
Сообщение: contrib library in windows
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Drop user doesn't drop granted privs?