GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables?

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables?
Дата
Msg-id 20181215021359.m4horbexxiai4xez@ler-imac-2.local
обсуждение исходный текст
Ответы Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables?  (Rob Sargent <robjsargent@gmail.com>)
Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables?  (Christopher Swingley <cswingle@swingleydev.com>)
Список pgsql-sql
I have the following grant in effect:
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly;

We occasionally add tables to that schema, but the readonly role
can't read them.

Is this a bug or do I/should I re-issue the GRANT when we add tables?




--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 214-642-9640                 E-Mail: ler@lerctr.org
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106

Вложения

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

Предыдущее
От: Shekar Tippur
Дата:
Сообщение: Changing csv structure and corresponding etl
Следующее
От: Christopher Swingley
Дата:
Сообщение: Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables?