Dropping default privileges.

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Dropping default privileges.
Дата
Msg-id CAGuHJrOwG1X7JwPU=RqLVFG=FQ+DgNaQVKhdJ8i6kPVB=gi0BQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Dropping default privileges.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I am unable to drop a user.

drop role tim;
ERROR:  role "tim" cannot be dropped because some objects depend on it
DETAIL:  owner of default privileges on new relations belonging to
role tim in schema strongmail

ALTER DEFAULT PRIVILEGES IN SCHEMA strongmail
    REVOKE INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES,
TRIGGER ON TABLES
    FROM tim;

drop role tim;
ERROR:  role "tim" cannot be dropped because some objects depend on it
DETAIL:  owner of default privileges on new relations belonging to
role tim in schema strongmail

reassign owned by tim to postgres;

Nothing seems to work.


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

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: Optimizing select count query which often takes over 10 seconds
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Dropping default privileges.