dropuser error - Mailing list pgsql-admin

From Sam Stearns
Subject dropuser error
Date
Msg-id CAN6TVj=sfdK=W08kVtVOcn_QLYtFby-jVxuw+F+UYM42fkt91A@mail.gmail.com
Whole thread Raw
Responses Re: dropuser error
Re: dropuser error
List pgsql-admin
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: Ron Johnson
Date:
Subject: Re: Replication using patroni on different ubuntu os versions
Next
From: sami l
Date:
Subject: Re: dropuser error