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 CAEcMXhmG4evh_uwMQuByghzEyR+5B-gP5gzW9rxiE9uMdMZ7gA@mail.gmail.com
Whole thread Raw
In response to Re: Cannot delete role because it depends on "default privileges"  (Durumdara <durumdara@gmail.com>)
List pgsql-general

Wooooooooooooooooooooow... I found it. The postgres database contained more default privs. But PGAdmin III nothing say about dependents in it's reports.

Thanks!

2016-10-21 16:19 GMT+02:00 Durumdara <durumdara@gmail.com>:
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: Durumdara
Date:
Subject: Re: Cannot delete role because it depends on "default privileges"
Next
From: Edilmar LISTAS
Date:
Subject: Doubts about replication from many servers