| From: | Sam Stearns <sam(dot)stearns(at)dat(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Cc: | Henry Ashu <henry(dot)ashu(at)dat(dot)com>, Julie Mather <julie(dot)mather(at)dat(dot)com> |
| Subject: | dropuser error |
| Date: | 2025-09-16 20:13:58 |
| Message-ID: | CAN6TVj=sfdK=W08kVtVOcn_QLYtFby-jVxuw+F+UYM42fkt91A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sami l | 2025-09-16 20:26:08 | Re: dropuser error |
| Previous Message | Ron Johnson | 2025-09-16 13:56:23 | Re: Replication using patroni on different ubuntu os versions |