Re: dropuser error

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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
>
>
>