Re: dropuser error
| От | Naveen Kumar |
|---|---|
| Тема | Re: dropuser error |
| Дата | |
| Msg-id | CADk76jpfQc23rr9FWwFy1MHr8PRBZA1qph+c0sPT7Y5AN+o5gg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: dropuser error (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-admin |
Check in csbtest DB for dependent objects. And there might be default privileges set for that role.
Thanks & Regards,
Naveen Kumar .M,Lead DBA
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
В списке pgsql-admin по дате отправления: