REVOKE question
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
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)