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
