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
