Re: dropped users appear as numbers in ACL - Mailing list pgsql-admin

From Tom Lane
Subject Re: dropped users appear as numbers in ACL
Date
Msg-id 15006.1068767846@sss.pgh.pa.us
Whole thread Raw
In response to Re: dropped users appear as numbers in ACL  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: dropped users appear as numbers in ACL
List pgsql-admin
Peter Eisentraut <peter_e@gmx.net> writes:
> DHS Webmaster writes:
>> Are there any plans to handle these issues transparently when a user is
>> dropped?

> "Wishlist" maybe, but no concrete plans.

The reason it's difficult is that users span databases; when you drop a
user in database A, you have no way of seeing/removing references to him
that exist in databases B, C, ...

I'm not sure there's any really good answer to this short of changing
the way that users and databases work, which so far no one has wanted
to do.

            regards, tom lane

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pg_restore and FK constraints with large dbs
Next
From: Peter Eisentraut
Date:
Subject: Re: dropped users appear as numbers in ACL