Re: dropping a user causes pain (#2) - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: dropping a user causes pain (#2)
Date
Msg-id Pine.LNX.4.56.0308111010510.1333@krusty.localdomain
Whole thread Raw
In response to Re: dropping a user causes pain (#2)  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List 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@gmx.net


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: src/interfaces/cli
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Farewell