Re: accessing cross-schema materialized views

[Rob Sargent <robjsargent@xxxxxxxxx>]

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 just a typo (phony names)?