Permission to refresh materialized view

Поиск
Список
Период
Сортировка
От Johann Spies
Тема Permission to refresh materialized view
Дата
Msg-id CAGZ55DQQDccu8UYu8c4jCW9Wq=ZkULKtF3Q2y3FfL+u5jcLWHA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Permission to refresh materialized view  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
We did run this query:

GRANT ALL ON ALL TABLES IN SCHEMA X TO USER Y;

But user Y gets the message that he has to be the owner of a materialized view to be able to refresh it.

Is that intended behaviour?  Is there a way to enable the user to refresh materialized views in that schema?

Regards
Johann

--
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

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

Предыдущее
От: Matthias Otterbach
Дата:
Сообщение: PG 10 vs. 11: Large increase in memory usage when selecting BYTEA data (actually out of memory with PG11)
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Permission to refresh materialized view