SV: Permission to refresh materialized view

From documentation:
"REFRESH MATERIALIZED VIEW completely replaces the contents of a materialized view. To execute this command you must be
theowner of the materialized view."  

So it is intended behavior.

https://www.postgresql.org/docs/11/sql-refreshmaterializedview.html

________________________________________
Från: Adrian Klaver [adrian.klaver@aklaver.com]
Skickat: den 18 mars 2019 15:51
Till: Johann Spies
Kopia: pgsql-general
Ämne: Re: Permission to refresh materialized view

On 3/17/19 11:52 PM, Johann Spies wrote:
Please reply to list also.
Ccing list.
>
>
> On Wed, 13 Mar 2019 at 16:24, Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 3/13/19 6:27 AM, Johann Spies wrote:
>     ...
>      > But user Y gets the message that he has to be the owner of a
>      > materialized view to be able to refresh it.
>
>     What is the exact message?
>
>
> [42501] ERROR: must be owner of materialized view xxx_mv
>
> Regards
> Johann
> --
> Because experiencing your loyal love is better than life itself,
> my lips will praise you.  (Psalm 63:3)


--
Adrian Klaver
adrian.klaver@aklaver.com