Tim Clarke <tim.clarke@xxxxxxxxxxxx> 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
