Request a Demo
Home   >   mailing lists

Re: dropuser error - Mailing list pgsql-admin

From sami l
Subject Re: dropuser error
Date
Msg-id CAGu5A9DbX7W+YzkMzi-t4=N8MYun_gM+ZV9AF3oAjZXc8nfycg@mail.gmail.com
Whole thread Raw
In response to dropuser error  (Sam Stearns <sam.stearns@dat.com>)
List pgsql-admin
Tree view
Hi,
Did you check the priviliges?

Sami LEKESİZ


16 Eyl 2025 Sal, saat 23:14 tarihinde Sam Stearns <sam.stearns@dat.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


pgsql-admin by date:

Previous
From: Sam Stearns
Date:
Subject: dropuser error
Next
From: Tom Lane
Date:
Subject: Re: dropuser error