Обсуждение: dropuser error

Поиск
Список
Период
Сортировка

dropuser error

От
Sam Stearns
Дата:
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


Re: dropuser error

От
sami l
Дата:
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


Re: dropuser error

От
Tom Lane
Дата:
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

Re: dropuser error

От
Naveen Kumar
Дата:
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 AM 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