From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dominique Devienne <ddevienne@gmail.com>
cc: "David G. Johnston" <david.g.johnston@gmail.com>,
        "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: DROP ROLE as SUPERUSER
In-reply-to: <CAFCRh-_2CiGRWxJ7q7ScW+L5xW9NKzTv_DFs9tsBQVJLFFPqJA@mail.gmail.com>
References: <CAFCRh-_3+E3-pmdH+i5jUE-8Z1jJWxxdP3EcFjTbHVWM+oEweg@mail.gmail.com> <CAKFQuwb-pHsxJF22fAp2Vb1jwbQxTVxXhuLzjaocsB5LEUEb5w@mail.gmail.com> <2705563.1740067550@sss.pgh.pa.us> <CAKFQuwa4iiw9zei549ROy1VaWTWT5dM1Ubw9aH7TdmbQS2iiGw@mail.gmail.com> <2765124.1740070338@sss.pgh.pa.us> <CAFCRh-9fRoVj6WhekQ2+E3riS6TC4HWHJJ4w8cJp=wFf3Q0NAw@mail.gmail.com> <3072990.1740148436@sss.pgh.pa.us> <CAFCRh--+406OqvQv60Yt9DXzS2cy9EN9Gz4hUx7sVKT9Ui7afQ@mail.gmail.com> <3073944.1740149062@sss.pgh.pa.us> <CAFCRh-_2CiGRWxJ7q7ScW+L5xW9NKzTv_DFs9tsBQVJLFFPqJA@mail.gmail.com>
Comments: In-reply-to Dominique Devienne <ddevienne@gmail.com>
	message dated "Tue, 29 Apr 2025 16:50:40 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <1031763.1745940704.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Tue, 29 Apr 2025 11:31:44 -0400
Message-ID: <1031764.1745940704@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1031764.1745940704%40sss.pgh.pa.us>
Precedence: bulk

Dominique Devienne <ddevienne@gmail.com> writes:
> On Fri, Feb 21, 2025 at 3:44 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> DROP OWNED also removes relevant permission entries (which can be
>> thought of as things owned by the role, if you hold your head at
>> the right angle).  See its man page.

> Except when it doesn't... I'm doing the DROP OWNED, and I'm getting
> several "WARNING:  no privileges could be revoked for ..." for SCHEMAs
> and ROUTINEs. (which BTW break my unit tests, which monitor outputs).

[ shrug... ]  With no details, it's impossible to comment on this.

			regards, tom lane