public inbox for [email protected]  

help / color / mirror / Atom feed
From: Tom Lane <[email protected]>
To: Dominique Devienne <[email protected]>
Cc: David G. Johnston <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: DROP ROLE as SUPERUSER
Date: Tue, 29 Apr 2025 11:31:44 -0400
Message-ID: <[email protected]> (raw)
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>
	<[email protected]>
	<CAKFQuwa4iiw9zei549ROy1VaWTWT5dM1Ubw9aH7TdmbQS2iiGw@mail.gmail.com>
	<[email protected]>
	<CAFCRh-9fRoVj6WhekQ2+E3riS6TC4HWHJJ4w8cJp=wFf3Q0NAw@mail.gmail.com>
	<[email protected]>
	<CAFCRh--+406OqvQv60Yt9DXzS2cy9EN9Gz4hUx7sVKT9Ui7afQ@mail.gmail.com>
	<[email protected]>
	<CAFCRh-_2CiGRWxJ7q7ScW+L5xW9NKzTv_DFs9tsBQVJLFFPqJA@mail.gmail.com>

Dominique Devienne <[email protected]> writes:
> On Fri, Feb 21, 2025 at 3:44 PM Tom Lane <[email protected]> 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






view thread (8+ messages)

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: DROP ROLE as SUPERUSER
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox