Drop user doesn't drop granted privs?

From: Pete Deffendol <peter(dot)deffendol(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Drop user doesn't drop granted privs?
Date: 2006-01-06 22:55:15
Message-ID: a1db1de60601061455k6aa46f39oee71ddc4c9f6031b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Pete

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2006-01-06 23:09:28 Re: Drop user doesn't drop granted privs?
Previous Message SunWuKung 2006-01-06 22:03:13 contrib library in windows