MIME-Version: 1.0
From: Sam Stearns <sam.stearns@dat.com>
Date: Tue, 16 Sep 2025 13:13:58 -0700
Message-ID: 
 <CAN6TVj=sfdK=W08kVtVOcn_QLYtFby-jVxuw+F+UYM42fkt91A@mail.gmail.com>
Subject: dropuser error
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Cc: Henry Ashu <henry.ashu@dat.com>, Julie Mather <julie.mather@dat.com>
Content-Type: multipart/alternative; boundary="00000000000056e7af063ef0c32d"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN6TVj%3DsfdK%3DW08kVtVOcn_QLYtFby-jVxuw%2BF%2BUYM42fkt91A%40mail.gmail.com>
Precedence: bulk

--00000000000056e7af063ef0c32d
Content-Type: text/plain; charset="UTF-8"

Howdy,

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

I have run queries to check for ownership on tables, views, sequences,
materialized views, functions, and schemas.  All return 0 (zero) rows.

Could anyone provide any advice here, please?

Thank you,

Sam

-- 

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com

<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>

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

<div dir=3D"ltr"><div>Howdy,</div><div><br></div><div>I&#39;m trying to dro=
p a user but getting the following error:</div><div><br></div><div>dropuser=
: error: removal of role &quot;dalec&quot; failed: ERROR: =C2=A0role &quot;=
dalec&quot; cannot be dropped because some objects depend on it<br>DETAIL: =
=C2=A0262 objects in database csbtest</div><div><br></div><div>I have run q=
ueries to check for ownership on tables, views, sequences, materialized vie=
ws, functions, and schemas.=C2=A0 All return 0 (zero) rows.</div><div><br><=
/div><div>Could anyone provide any advice here, please?</div><div><br></div=
><div>Thank you,</div><div><br></div><div>Sam</div><div><br></div><span cla=
ss=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail=
_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><span><p di=
r=3D"ltr" style=3D"line-height:1.38;margin-top:10pt;margin-bottom:10pt"><sp=
an style=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(51,51,51)=
;background-color:transparent;font-weight:700;vertical-align:baseline">Samu=
el Stearns</span><span style=3D"font-size:11pt;font-family:Inter,sans-serif=
;color:rgb(51,51,51);background-color:transparent;font-weight:700;vertical-=
align:baseline"><br></span><span style=3D"font-size:11pt;font-family:Inter,=
sans-serif;color:rgb(102,102,102);background-color:transparent;vertical-ali=
gn:baseline">Team Lead - Database</span><span style=3D"font-size:11pt;font-=
family:Inter,sans-serif;color:rgb(102,102,102);background-color:transparent=
;vertical-align:baseline"><br></span><span style=3D"font-size:11pt;font-fam=
ily:Inter,sans-serif;color:rgb(102,102,102);background-color:transparent;ve=
rtical-align:baseline">c: 971 762 6879 </span><span style=3D"font-size:11pt=
;font-family:Inter,sans-serif;color:rgb(147,149,152);background-color:trans=
parent;vertical-align:baseline">|</span><span style=3D"font-size:11pt;font-=
family:Inter,sans-serif;color:rgb(102,102,102);background-color:transparent=
;vertical-align:baseline"> o: 971 762 6879 </span><span style=3D"font-size:=
11pt;font-family:Inter,sans-serif;color:rgb(147,149,152);background-color:t=
ransparent;vertical-align:baseline">|</span><span style=3D"font-size:11pt;f=
ont-family:Inter,sans-serif;color:rgb(102,102,102);background-color:transpa=
rent;vertical-align:baseline"> DAT.com</span></p><p dir=3D"ltr" style=3D"li=
ne-height:1.38;margin-top:0pt;margin-bottom:0pt"><a href=3D"https://www.dat=
.com/?utm_medium=3Demail&amp;utm_source=3DDAT_email_signature_link" target=
=3D"_blank"><span style=3D"font-size:11pt;font-family:Arial,sans-serif;colo=
r:rgb(17,85,204);background-color:transparent;vertical-align:baseline"><spa=
n style=3D"border:none;display:inline-block;overflow:hidden;width:126px;hei=
ght:54px"><img src=3D"https://lh7-rt.googleusercontent.com/docsz/AD_4nXchMT=
XZiU3P-OkN7UwPyrdxiCAOkHWIArmSrehhAl-cXaYxECakbMV5owUfMaMjAZZcbjttr8pEtSGrZ=
jUSRNaxbLxumAthLgYlFE5iT2P2eOJu4jtqizp_fYM0Mq1DZyFUeHMhpGKjiGIzqD_ny_hPIzlt=
?key=3Dz3dM0-Cr9WzKyLauPVBgWw" width=3D"126" height=3D"54" style=3D"margin-=
left:0px;margin-top:0px"></span></span></a></p><div><br></div></span></div>=
</div></div>

--00000000000056e7af063ef0c32d--