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 the owner of the materialized view."

So it is intended behavior.

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

________________________________________
Från: Adrian Klaver [adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com