| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| 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 21:27:05 |
| Message-ID: | 1395876.1758058025@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Sam Stearns <sam(dot)stearns(at)dat(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Naveen Kumar | 2025-09-16 21:30:05 | Re: dropuser error |
| Previous Message | sami l | 2025-09-16 20:26:08 | Re: dropuser error |