On 31/03/2021 23:42, Tom Lane wrote:
> 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
That nailed
Tim Clarke 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 de
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
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
