Re: accessing cross-schema materialized views

Tim Clarke <tim.clarke@minerva.info> writes:
> 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

> and yet we receive "permission denied for materialized view" on a user with the mygroup role selecting from
schema2.usingview?

The owner of the schema2.usingview is the one who must have
privilege to read the underlying schema1.matview.  Our
permissions messages are, I fear, frequently not very good
about saying whose privileges were checked.

            regards, tom lane