Re: Cannot delete role because it depends on "default privileges" - Mailing list pgsql-general

From Durumdara
Subject Re: Cannot delete role because it depends on "default privileges"
Date
Msg-id CAEcMXhmAMk-AQ-02wOqoZPR=L6p7Lz3mSxC-wTCVeJFjQ2dm_w@mail.gmail.com
Whole thread Raw
In response to Re: Cannot delete role because it depends on "default privileges"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Cannot delete role because it depends on "default privileges"
List pgsql-general
Dear Tom!

Is there any tool what can show me the dependents or dependencies?

In PGAdmin I don't see any dependencies or dependents... :-(

Thanks
   dd

2016-10-21 16:08 GMT+02:00 Tom Lane <tgl@sss.pgh.pa.us>:
Durumdara <durumdara@gmail.com> writes:
> The DB_X dropped, so I can't choose it as "actual database".
> I tried this in a neutral database:
>     drop owned by role_x;
> But nothing happened, the error is same.

The error you are reporting is describing default privileges that
exist in the *current* database.  You need to do DROP OWNED BY
in that database (and maybe other ones, but start there).

                        regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cannot delete role because it depends on "default privileges"
Next
From: Durumdara
Date:
Subject: Re: Cannot delete role because it depends on "default privileges"