REVOKE question

Поиск
Список
Период
Сортировка
Искать
От
Bohdan Linda
Тема
REVOKE question
Дата
Msg-id
20050902153154.GA19356@bafster.chello.upc.cz
Список
Дерево обсуждения
REVOKE question Bohdan Linda <bohdan.linda@seznam.cz>
Re: REVOKE question Alvaro Herrera <alvherre@alvh.no-ip.org>

Hello,

I have encountered on (for me) wierd thing. When dropping an user, the
database will not forget his permissions. After his recreation he has the
original permissions.

I use an approach of dropping all users when recreating the database
environment and user recreation to avoid any unwanted/temporary changes to
permissions. 

Is there any way, how to revoke all permission for the user on any type in
any schema in the database? I think this is essential for securying of
access control of users. I tried to look in the doc, but found nothing
about that.

Thank you,
bohdan 
В списке pgsql-general по дате отправления
От: Terry Lee Tucker
Дата:
Сообщение: Re: Question regarding FOUND
От: Alvaro Herrera
Дата:
Сообщение: Re: REVOKE question
FAQ