Re: dropped users appear as numbers in ACL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: DHS Webmaster <webmaster(at)dhs-club(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: dropped users appear as numbers in ACL
Date: 2003-11-13 23:57:26
Message-ID: 15006.1068767846@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Peter Eisentraut <peter_e(at)gmx(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2003-11-14 00:10:55 Re: dropped users appear as numbers in ACL
Previous Message Peter Eisentraut 2003-11-13 23:44:37 Re: pg_restore and FK constraints with large dbs