Re: dropuser error

From: sami l <samilekesiz(at)gmail(dot)com>
To: Sam Stearns <sam(dot)stearns(at)dat(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, Henry Ashu <henry(dot)ashu(at)dat(dot)com>, Julie Mather <julie(dot)mather(at)dat(dot)com>
Subject: Re: dropuser error
Date: 2025-09-16 20:26:08
Message-ID: CAGu5A9DbX7W+YzkMzi-t4=N8MYun_gM+ZV9AF3oAjZXc8nfycg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
Did you check the priviliges?

*Sami LEKESİZ*

16 Eyl 2025 Sal, saat 23:14 tarihinde Sam Stearns <sam(dot)stearns(at)dat(dot)com>
şunu yazdı:

> 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>
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2025-09-16 21:27:05 Re: dropuser error
Previous Message Sam Stearns 2025-09-16 20:13:58 dropuser error