public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Dominique Devienne <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: DROP ROLE as SUPERUSER
Date: Thu, 20 Feb 2025 09:29:40 -0700
Message-ID: <CAKFQuwYxPq4UNkiRODjQu8KkqOE9G0r1CpoX6ZvfiGab62N9dw@mail.gmail.com> (raw)
In-Reply-To: <CAFCRh-8cS+crZ52=TQcMWy1rasCiKr9PrnCU9CObXfiNJFXYEg@mail.gmail.com>
References: <CAFCRh-_3+E3-pmdH+i5jUE-8Z1jJWxxdP3EcFjTbHVWM+oEweg@mail.gmail.com>
<CAKFQuwb-pHsxJF22fAp2Vb1jwbQxTVxXhuLzjaocsB5LEUEb5w@mail.gmail.com>
<[email protected]>
<CAFCRh-8cS+crZ52=TQcMWy1rasCiKr9PrnCU9CObXfiNJFXYEg@mail.gmail.com>
On Thu, Feb 20, 2025 at 9:21 AM Dominique Devienne <[email protected]>
wrote:
> But that's not much better. It's basically like the SET ROLE to the
> GRANTOR I did.
> I guess what I want is GRANTED BY ANYONE! And not have to figure out
> GRANTOR(s).
>
Your stated use case is dropping a role. Does the combination of reassign
and drop owned not fulfill the requirements?
https://www.postgresql.org/docs/current/role-removal.html
Also, you had to know the role you wanted to drop so you already figured
out the grantor.
David J.
view thread (8+ messages) latest in thread
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: <CAKFQuwYxPq4UNkiRODjQu8KkqOE9G0r1CpoX6ZvfiGab62N9dw@mail.gmail.com>
* 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