På mandag 27. mai 2024 kl. 11:10:10, skrev Laurenz Albe < [email protected] <mailto:[email protected]>>: On Mon, 2024-05-27 at 09:33 +0200, Andreas Joseph Krogh wrote: > I tried: > > REVOKE SELECT ON pg_catalog.pg_database FROM public; > > But that doesn't prevent a normal user from querying pg_database it seems…
It works here. Perhaps the "normal" user is a member of "pg_read_all_data". Yours, Laurenz Albe Don't think so: andreak@[local]:5432 16.3 andreak=# REVOKE pg_read_all_data from nisse; WARNING: role "nisse" has not been granted membership in role "pg_read_all_data" by role "postgres" REVOKE ROLE Any hints welcome. -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 [email protected] <mailto:[email protected]> www.visena.com <https://www.visena.com> <https://www.visena.com>
