MIME-Version: 1.0
References: 
 <CAN6TVj=sfdK=W08kVtVOcn_QLYtFby-jVxuw+F+UYM42fkt91A@mail.gmail.com>
 <1395876.1758058025@sss.pgh.pa.us>
In-Reply-To: <1395876.1758058025@sss.pgh.pa.us>
From: Naveen Kumar <naveenchowdaryon@gmail.com>
Date: Wed, 17 Sep 2025 03:00:05 +0530
Message-ID: 
 <CADk76jpfQc23rr9FWwFy1MHr8PRBZA1qph+c0sPT7Y5AN+o5gg@mail.gmail.com>
Subject: Re: dropuser error
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Sam Stearns <sam.stearns@dat.com>,
 Pgsql-admin <pgsql-admin@lists.postgresql.org>,
	Henry Ashu <henry.ashu@dat.com>, Julie Mather <julie.mather@dat.com>
Content-Type: multipart/alternative; boundary="0000000000007a2d3c063ef1d3a1"
Archived-At: 
 <https://www.postgresql.org/message-id/CADk76jpfQc23rr9FWwFy1MHr8PRBZA1qph%2Bc0sPT7Y5AN%2Bo5gg%40mail.gmail.com>
Precedence: bulk

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

Check in *csbtest *DB for dependent objects. And there might be default
privileges set for that role.

Thanks & Regards,
Naveen Kumar .M,
Lead DBA
Mobile: 7755929449.


On Wed, Sep 17, 2025 at 2:57=E2=80=AFAM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Sam Stearns <sam.stearns@dat.com> writes:
> > I'm trying to drop a user but getting the following error:
>
> > dropuser: error: removal of role "dalec" failed: ERROR:  role "dalec"
> > cannot be dropped because some objects depend on it
> > DETAIL:  262 objects in database csbtest
>
> If the display looks like that rather than itemizing the objects,
> it's because they are in a different database of the cluster.
> You need to connect to the "csbtest" database and then you can
> drop or reassign ownership of those objects.
>
> (The subtext here is that users/roles are shared across the
> whole cluster, but most object kinds are local to one database.
> You can't "see" the details of objects in a different database
> than the one you're connected to.  DROP USER knows that there
> are some dependencies, but not much more.)
>
>                         regards, tom lane
>
>
>

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

<div dir=3D"ltr"><div>Check in <b>csbtest </b>DB for dependent objects. And=
 there might be default privileges=C2=A0set for that role.</div><div><br></=
div><div><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail=
_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div><div><div><spa=
n style=3D"font-family:verdana,sans-serif">Thanks &amp; Regards,<br></span>=
</div><span style=3D"font-family:verdana,sans-serif">Naveen Kumar .M,<br>Le=
ad DBA</span></div></div><span style=3D"font-family:verdana,sans-serif">Mob=
ile: 7755929449</span>.<br></div></div><div dir=3D"ltr"><br></div></div></d=
iv></div></div><br></div><br><div class=3D"gmail_quote gmail_quote_containe=
r"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Sep 17, 2025 at 2:57=E2=80=
=AFAM Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Sa=
m Stearns &lt;<a href=3D"mailto:sam.stearns@dat.com" target=3D"_blank">sam.=
stearns@dat.com</a>&gt; writes:<br>
&gt; I&#39;m trying to drop a user but getting the following error:<br>
<br>
&gt; dropuser: error: removal of role &quot;dalec&quot; failed: ERROR:=C2=
=A0 role &quot;dalec&quot;<br>
&gt; cannot be dropped because some objects depend on it<br>
&gt; DETAIL:=C2=A0 262 objects in database csbtest<br>
<br>
If the display looks like that rather than itemizing the objects,<br>
it&#39;s because they are in a different database of the cluster.<br>
You need to connect to the &quot;csbtest&quot; database and then you can<br=
>
drop or reassign ownership of those objects.<br>
<br>
(The subtext here is that users/roles are shared across the<br>
whole cluster, but most object kinds are local to one database.<br>
You can&#39;t &quot;see&quot; the details of objects in a different databas=
e<br>
than the one you&#39;re connected to.=C2=A0 DROP USER knows that there<br>
are some dependencies, but not much more.)<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
<br>
<br>
</blockquote></div>

--0000000000007a2d3c063ef1d3a1--