Re: dropping a user causes pain (#2)

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: dropping a user causes pain (#2)
Date: 2003-08-11 08:12:05
Message-ID: Pine.LNX.4.56.0308111010510.1333@krusty.localdomain
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christopher Kings-Lynne writes:

> Ah OK, I must have been thinking of the database owner check. I'd vote for
> (1) checking that they own no objects and by default owning all their stuff
> to the database owner.

The reason none of this will work is that users are global, so when you
drop a user, you would have to dig through all databases to do whatever
action you imagine. That is not possible.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message D'Arcy J.M. Cain 2003-08-11 08:23:03 Re: Farewell
Previous Message Peter Eisentraut 2003-08-11 08:01:59 Re: src/interfaces/cli