[GENERAL] How to delete default privileges

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема [GENERAL] How to delete default privileges
Дата
Msg-id 11bbc65c-1087-08c8-397c-69c78bbd1838@natserv.net
обсуждение исходный текст
Ответы Re: [GENERAL] How to delete default privileges
Список pgsql-general
I have a DB where we changed ownership of all objects.

We had:

ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT SELECT ON tables
TO dbgroup_ro_group;
ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT SELECT ON sequences
TO dbgroup_ro_group;

ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT SELECT, UPDATE,
DELETE, INSERT ON tables    TO dbgroup_rw_group;
ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT SELECT,
USAGE                  ON sequences TO dbgroup_rw_group;
ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT
EXECUTE                        ON functions TO dbgroup_rw_group;


But now there is a new DB owner and I have run the above, but with
new_dbowner. How can I delete the old default grants? Can't find
examples and don't see it on the documentation either.


Any help would be greatly appreciated.



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

Предыдущее
От: Daryl Stultz
Дата:
Сообщение: Re: [GENERAL] Corrupt index
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: [GENERAL] How to delete default privileges