MIME-Version: 1.0
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>
In-Reply-To: <3072990.1740148436@sss.pgh.pa.us>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Fri, 21 Feb 2025 15:35:19 +0100
Message-ID: <CAFCRh--+406OqvQv60Yt9DXzS2cy9EN9Gz4hUx7sVKT9Ui7afQ@mail.gmail.com>
Subject: Re: DROP ROLE as SUPERUSER
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005102c0062ea7e7f3"
Archived-At: <https://www.postgresql.org/message-id/CAFCRh--%2B406OqvQv60Yt9DXzS2cy9EN9Gz4hUx7sVKT9Ui7afQ%40mail.gmail.com>
Precedence: bulk

--0000000000005102c0062ea7e7f3
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Feb 21, 2025 at 3:33=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Dominique Devienne <ddevienne@gmail.com> writes:
> > The point I'm trying to make, is that "hunting down" grantor(s) to
> connect
> > to DB(s) to be able to "force drop" a ROLE is a PITA. And I really wish
> > there
> > was an easier way to drop a role in that situation. --DD
>
> REASSIGN OWNED then DROP OWNED is the recommended path.
>

Hi. Am I missing something? foobar does not OWN anything in this case.
So I don't see how these recommendations are relevant to this particular
case. --DD

--0000000000005102c0062ea7e7f3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Feb 21, 2025 at 3:33=E2=80=AFPM T=
om Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; =
wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">Dominique Devienne &lt;<a href=3D"mailt=
o:ddevienne@gmail.com" target=3D"_blank">ddevienne@gmail.com</a>&gt; writes=
:<br>
&gt; The point I&#39;m trying to make, is that &quot;hunting down&quot; gra=
ntor(s) to connect<br>
&gt; to DB(s) to be able to &quot;force drop&quot; a ROLE is a PITA. And I =
really wish<br>
&gt; there<br>
&gt; was an easier way to drop a role in that situation. --DD<br>
<br>
REASSIGN OWNED then DROP OWNED is the recommended path.<br></blockquote><di=
v><br></div><div>Hi. Am I missing something? foobar does not OWN anything i=
n this case.</div><div>So I don&#39;t see how these recommendations are rel=
evant to this particular case. --DD</div></div></div>

--0000000000005102c0062ea7e7f3--