Обсуждение: REVOKE question

Поиск
Список
Период
Сортировка

REVOKE question

От
Bohdan Linda
Дата:
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

Re: REVOKE question

От
Alvaro Herrera
Дата:
On Fri, Sep 02, 2005 at 05:31:54PM +0200, Bohdan Linda wrote:

> 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.

Known problem, partially fixed in 8.1.  (At least it won't allow you to
drop the user if it owns something, or is mentioned in an ACL.)

--
Alvaro Herrera -- Valdivia, Chile         Architect, www.EnterpriseDB.com
"Some men are heterosexual, and some are bisexual, and some
men don't think about sex at all... they become lawyers" (Woody Allen)