accessing cross-schema materialized views

From: Tim Clarke <tim(dot)clarke(at)minerva(dot)info>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: accessing cross-schema materialized views
Date: 2021-03-31 22:31:38
Message-ID: 76fe4f3e-5e91-3199-0f70-5f20ba1e142a@minerva.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 same user can select from schema1.matview without issue?

I must be tired and I can't see why that should fail.... :(

--
Tim Clarke

Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
Web: https://www.manifest.co.uk/

Minerva Analytics Ltd - A Solactive Company
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom

________________________________

Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin(at)minerva(dot)info<mailto:admin(at)minerva(dot)info>
Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2021-03-31 22:36:50 Re: accessing cross-schema materialized views
Previous Message Martin 2021-03-31 22:27:15 Re: Failed to initialize 13.2-1 cluster on Windows