-----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] Sent: Wednesday, March 13, 2019 10:24 AM To: Johann Spies <johann.spies@xxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx Subject: Re: Permission to refresh materialized view On 3/13/19 6:27 AM, Johann Spies wrote: > 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. What is the exact message? > > Is that intended behaviour? Is there a way to enable the user to > refresh materialized views in that schema? What is the definition of the view? > > Regards > Johann > // > > -- > Because experiencing your loyal love is better than life itself, my > lips will praise you. (Psalm 63:3) -- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Lacking the actual error message however: Y might lack usage on the containing schema ? Y might lack privilege on a function or sequence contained in the view ? Dave Day
