Drop a user leaves permissions!

Поиск
Список
Период
Сортировка
От Trewern, Ben
Тема Drop a user leaves permissions!
Дата
Msg-id 996802F75C3CD411B424001083FA445B05953D@CET_PONXX_FP001
обсуждение исходный текст
Список pgsql-general
I'm using PostgreSQL and I've been working with permissions.
I've tried the following:

CREATE USER ben;
GRANT ALL ON table1 TO ben;
DROP USER ben;

The permissions get left to the table as in :

     Relation    |      Access permissions
------------------------------------------------------
table1            | {"=","51=arwR"}

I assume that 51 is the ID of the user who was dropped.
Is this a bug?  How should I clean up the permissions?

thanks

Ben

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

Предыдущее
От: "Brent R. Matzelle"
Дата:
Сообщение: Re: ALTER DROP COLUMN
Следующее
От: Anand Raman
Дата:
Сообщение: Re: [araman@india-today.com: locking problem with JDBC (suspicion)]