Permission to refresh materialized view

From: Johann Spies <johann(dot)spies(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Permission to refresh materialized view
Date: 2019-03-13 13:27:20
Message-ID: CAGZ55DQQDccu8UYu8c4jCW9Wq=ZkULKtF3Q2y3FfL+u5jcLWHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-03-13 14:24:10 Re: Permission to refresh materialized view
Previous Message Matthias Otterbach 2019-03-13 11:24:00 PG 10 vs. 11: Large increase in memory usage when selecting BYTEA data (actually out of memory with PG11)