dropped users appear as numbers in ACL

From: DHS Webmaster <webmaster(at)dhs-club(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: dropped users appear as numbers in ACL
Date: 2003-11-13 20:36:38
Message-ID: 3FB3EB56.F40DA1DF@dhs-club.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have experienced this in the past with members of groups, but now with
relation ACLs. It goes like this:
Certain users are given specific permissions of different tables and
such.
The users are later dropped but reference to them remains in the ACL as
their former ID number.
When trying to revoke permissions on the number, it fails.
I noticed this with groups in the past and have become accustomed to
deleting these users from the groups before dropping them. Otherwise I
had to create dummy users with those IDs, go about cleaning things out
and then drop the dummy user.
Will I have to perform this same procedure for ACLs?
Are there any plans to handle these issues transparently when a user is
dropped?
--
Bill MacArthur
Webmaster
DHS Club

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2003-11-13 20:54:25 Re: dropped users appear as numbers in ACL
Previous Message banghe 2003-11-13 18:14:05 Re: SQL-Statement