Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC

Hei all.

Motivation: I have PowerBI users, with a separate ‘reporting’-role, accessing
a database and I want to prevent them from listing all tables, users, databases
and view-definitions (to not see the underlying query).

I'm evaluating this:
REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC; REVOKE SELECT ON
ALL TABLES IN SCHEMA information_schema FROM PUBLIC;
Will this affect “normal behaviour”, ie. prevent the planner, or other
internal mechanisms, from working properly for sessions logged in with the
‘reporting’-role?

Thanks.

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>