SV: Permission to refresh materialized view

izedview.html Från: Adrian Klaver [adrian.kla...@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. > > &g

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 > 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 >

RE: Permission to refresh materialized view

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, March 13, 2019 10:24 AM To: Johann Spies ; pgsql-gene...@postgresql.org Subject: Re: Permission to refresh materialized view On 3/13/19 6:27 AM, Johann Spies wrote: > We did run this qu

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 wa

Permission to refresh materialized 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 J