Re: accessing cross-schema materialized views

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: accessing cross-schema materialized views
Date: 2021-03-31 22:36:50
Message-ID: 841410d9-1221-e2cb-0de4-dfb36f6d1de7@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/31/21 4:31 PM, Tim Clarke wrote:
>
> We have:
>
>     create materialized view schema1.matview.....
>     grant select on table schema1.matview to mygroup
>
>     create view schema2.usingview as select ... from schema1.matview
>     grant select on table schema2.using to mygroup
>
Is that schema2.using just a typo (phony names)?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-03-31 22:42:05 Re: accessing cross-schema materialized views
Previous Message Tim Clarke 2021-03-31 22:31:38 accessing cross-schema materialized views