Cannot delete role because it depends on "default privileges"

Поиск
Список
Период
Сортировка
От Durumdara
Тема Cannot delete role because it depends on "default privileges"
Дата
Msg-id CAEcMXhk4qa5oixef4VtERo0oA6KMWAnU+TXW=vsAzwHTbaGndA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Cannot delete role because it depends on "default privileges"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello!

We created a DB named DB_X, and a role ROLE_X.

We have a ROLE_MAIN.
This gave default privileges to all next objects in DB_X to ROLE_X.

Somebody dropped DB_X, and later he tried to drop ROLE_X.
But he got errors in PGAdmin.

---------------------------
pgAdmin III
---------------------------
An error has occurred:
ERROR:  role "role_x" cannot be dropped because some objects depend on it
DETAIL:  privileges for default privileges on new types belonging to role role_main
privileges for default privileges on new functions belonging to role role_main
privileges for default privileges on new sequences belonging to role role_main
privileges for default privileges on new relations belonging to role role_main
privileges for default privileges on new types belonging to role postgres
privileges for default privileges on new functions belonging to role postgres
privileges for default privileges on new sequences belonging to role postgres
privileges for default privileges on new relations belonging to role postgres
---------------------------
OK  
---------------------------

How to we remove the default privileges from role_x to we can drop it?

Thank you!

    dd

В списке pgsql-general по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: out-of-order XID insertion in KnownAssignedXids
Следующее
От: Alexander Farber
Дата:
Сообщение: Re: Selecting records with highest timestamp - for a join