MIME-Version: 1.0
References: 
 <CAN6TVj=sfdK=W08kVtVOcn_QLYtFby-jVxuw+F+UYM42fkt91A@mail.gmail.com>
In-Reply-To: 
 <CAN6TVj=sfdK=W08kVtVOcn_QLYtFby-jVxuw+F+UYM42fkt91A@mail.gmail.com>
From: sami l <samilekesiz@gmail.com>
Date: Tue, 16 Sep 2025 23:26:08 +0300
Message-ID: 
 <CAGu5A9DbX7W+YzkMzi-t4=N8MYun_gM+ZV9AF3oAjZXc8nfycg@mail.gmail.com>
Subject: Re: dropuser error
To: Sam Stearns <sam.stearns@dat.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>,
 Henry Ashu <henry.ashu@dat.com>,
	Julie Mather <julie.mather@dat.com>
Content-Type: multipart/alternative; boundary="000000000000c7ed44063ef0eecc"
Archived-At: 
 <https://www.postgresql.org/message-id/CAGu5A9DbX7W%2BYzkMzi-t4%3DN8MYun_gM%2BZV9AF3oAjZXc8nfycg%40mail.gmail.com>
Precedence: bulk

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

Hi,
Did you check the priviliges?

*Sami LEKES=C4=B0Z*


16 Eyl 2025 Sal, saat 23:14 tarihinde Sam Stearns <sam.stearns@dat.com>
=C5=9Funu yazd=C4=B1:

> 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=3Demail&utm_source=3DDAT_email_signature=
_link>
>
>

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

<div dir=3D"auto">Hi,</div><div dir=3D"auto">Did you check the priviliges?<=
br clear=3D"all"><br clear=3D"all"><div dir=3D"auto"><div dir=3D"ltr" class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><d=
iv style=3D"text-align:right" dir=3D"auto"><i style=3D"border-color:rgb(255=
,255,255)"><font style=3D"font-family:arial,helvetica,sans-serif;color:rgb(=
11,83,148)">Sami LEKES=C4=B0Z</font></i><br></div></div></div></div></div><=
div><br></div><div><br><div class=3D"gmail_quote gmail_quote_container"><di=
v dir=3D"ltr" class=3D"gmail_attr">16 Eyl 2025 Sal, saat 23:14 tarihinde Sa=
m Stearns &lt;<a href=3D"mailto:sam.stearns@dat.com">sam.stearns@dat.com</a=
>&gt; =C5=9Funu yazd=C4=B1:<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid=
;padding-left:1ex;border-left-color:rgb(204,204,204)"><div dir=3D"ltr"><div=
>Howdy,</div><div><br></div><div>I&#39;m trying to drop a user but getting =
the following error:</div><div><br></div><div>dropuser: error: removal of r=
ole &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 queries to check for o=
wnership on tables, views, sequences, materialized views, functions, and sc=
hemas.=C2=A0 All return 0 (zero) rows.</div><div><br></div><div>Could anyon=
e provide any advice here, please?</div><div><br></div><div>Thank you,</div=
><div><br></div><div>Sam</div></div><div dir=3D"ltr"><div><br></div><span c=
lass=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gma=
il_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><span><p =
dir=3D"ltr" style=3D"line-height:1.38;margin-top:10pt;margin-bottom:10pt"><=
span style=3D"font-size:11pt;font-family:Inter,sans-serif;font-weight:700;v=
ertical-align:baseline;background-color:transparent;color:rgb(51,51,51)">Sa=
muel Stearns</span><span style=3D"font-size:11pt;font-family:Inter,sans-ser=
if;font-weight:700;vertical-align:baseline;background-color:transparent;col=
or:rgb(51,51,51)"><br></span><span style=3D"font-size:11pt;font-family:Inte=
r,sans-serif;vertical-align:baseline;background-color:transparent;color:rgb=
(102,102,102)">Team Lead - Database</span><span style=3D"font-size:11pt;fon=
t-family:Inter,sans-serif;vertical-align:baseline;background-color:transpar=
ent;color:rgb(102,102,102)"><br></span><span style=3D"font-size:11pt;font-f=
amily:Inter,sans-serif;vertical-align:baseline;background-color:transparent=
;color:rgb(102,102,102)">c: 971 762 6879 </span><span style=3D"font-size:11=
pt;font-family:Inter,sans-serif;vertical-align:baseline;background-color:tr=
ansparent;color:rgb(147,149,152)">|</span><span style=3D"font-size:11pt;fon=
t-family:Inter,sans-serif;vertical-align:baseline;background-color:transpar=
ent;color:rgb(102,102,102)"> o: 971 762 6879 </span><span style=3D"font-siz=
e:11pt;font-family:Inter,sans-serif;vertical-align:baseline;background-colo=
r:transparent;color:rgb(147,149,152)">|</span><span style=3D"font-size:11pt=
;font-family:Inter,sans-serif;vertical-align:baseline;background-color:tran=
sparent;color:rgb(102,102,102)"> DAT.com</span></p><p dir=3D"ltr" style=3D"=
line-height:1.38;margin-top:0pt;margin-bottom:0pt"><a href=3D"https://www.d=
at.com/?utm_medium=3Demail&amp;utm_source=3DDAT_email_signature_link" targe=
t=3D"_blank"><span style=3D"font-size:11pt;font-family:Arial,sans-serif;ver=
tical-align:baseline;background-color:transparent;color:rgb(17,85,204)"><sp=
an style=3D"border:medium;display:inline-block;overflow:hidden;width:126px;=
height:54px;font-family:Arial,sans-serif"><img src=3D"https://lh7-rt.google=
usercontent.com/docsz/AD_4nXchMTXZiU3P-OkN7UwPyrdxiCAOkHWIArmSrehhAl-cXaYxE=
CakbMV5owUfMaMjAZZcbjttr8pEtSGrZjUSRNaxbLxumAthLgYlFE5iT2P2eOJu4jtqizp_fYM0=
Mq1DZyFUeHMhpGKjiGIzqD_ny_hPIzlt?key=3Dz3dM0-Cr9WzKyLauPVBgWw" width=3D"126=
" height=3D"54" style=3D"margin-left: 0px; margin-top: 0px; font-family: Ar=
ial, sans-serif;"></span></span></a></p><div><br></div></span></div></div><=
/div>
</blockquote></div></div>

--000000000000c7ed44063ef0eecc--