prevent users from SELECT-ing from pg_roles/pg_database

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: prevent users from SELECT-ing from pg_roles/pg_database
Date: 2024-05-24 15:51:59
Message-ID: VisenaEmail.66.54f51e587b38c9cc.18fab4b4eb6@origo-test01.app.internal.visena.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, is there a way to prevent a user/role from SELECT-ing from certain
system-tables?

I'd like the contents of pg_{user,roles,database} to not be visible to all
users.

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>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Muhammad Salahuddin Manzoor 2024-05-24 16:28:20 Re: prevent users from SELECT-ing from pg_roles/pg_database
Previous Message bruno vieira da silva 2024-05-24 10:31:18 Re: PG 12.2 ERROR: cannot freeze committed xmax