Re: Cannot delete role because it depends on "default privileges"

Поиск
Список
Период
Сортировка
От Durumdara
Тема Re: Cannot delete role because it depends on "default privileges"
Дата
Msg-id CAEcMXhmG4evh_uwMQuByghzEyR+5B-gP5gzW9rxiE9uMdMZ7gA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Cannot delete role because it depends on "default privileges"  (Durumdara <durumdara@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Durumdara
Дата:
Сообщение: Re: Cannot delete role because it depends on "default privileges"
Следующее
От: Edilmar LISTAS
Дата:
Сообщение: Doubts about replication from many servers