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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cannot delete role because it depends on "default privileges"
Дата
Msg-id 23791.1477058911@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Cannot delete role because it depends on "default privileges"  (Durumdara <durumdara@gmail.com>)
Ответы Re: Cannot delete role because it depends on "default privileges"  (Durumdara <durumdara@gmail.com>)
Список pgsql-general
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"
Следующее
От: Durumdara
Дата:
Сообщение: Re: Cannot delete role because it depends on "default privileges"