Re: I can't drop a user if I don't drop his grants beforehand?????????????????? - Mailing list pgsql-general

From Tom Lane
Subject Re: I can't drop a user if I don't drop his grants beforehand??????????????????
Date
Msg-id 26625.1243009490@sss.pgh.pa.us
Whole thread Raw
In response to I can't drop a user if I don't drop his grants beforehand??????????????????  (Nico Sabbi <nsabbi@officinedigitali.it>)
Responses Re: I can't drop a user if I don't drop his grants beforehand??????????????????  (Nico Sabbi <nsabbi@officinedigitali.it>)
List pgsql-general
Nico Sabbi <nsabbi@officinedigitali.it> writes:
> i can't believe my eyes. Why on earth I can't drop a user without
> previously revoking his privileges?

Yeah, it's a known limitation.  The reason it's not implemented is that
some of the privileges may be in other databases besides the particular
one you're connected to, and the backend hasn't got any way to get at
those databases to remove the entries.

Maybe someday it'll get fixed, but don't hold your breath.

            regards, tom lane

pgsql-general by date:

Previous
From: Nico Sabbi
Date:
Subject: I can't drop a user if I don't drop his grants beforehand??????????????????
Next
From: Nico Sabbi
Date:
Subject: Re: I can't drop a user if I don't drop his grants beforehand??????????????????