Re: Drop user doesn't drop granted privs?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Pete Deffendol <peter(dot)deffendol(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Drop user doesn't drop granted privs?
Date: 2006-01-06 23:09:28
Message-ID: 20060106230928.GA6026@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Pete Deffendol (peter(dot)deffendol(at)gmail(dot)com) wrote:
> 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?

8.1 has improvments in this area...

Thanks,

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike 2006-01-06 23:38:44 Re: How to search?
Previous Message Pete Deffendol 2006-01-06 22:55:15 Drop user doesn't drop granted privs?