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