Postgres Pro
Downloads
Home   >   mailing lists

Permission to refresh materialized view - Mailing list pgsql-general

From Johann Spies
Subject Permission to refresh materialized view
Date
Msg-id CAGZ55DQQDccu8UYu8c4jCW9Wq=ZkULKtF3Q2y3FfL+u5jcLWHA@mail.gmail.com
Whole thread Raw
Responses Re: Permission to refresh materialized view  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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 by date:

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