Horton

prevent users from SELECT-ing from pg_roles/pg_database

Andreas Joseph Krogh <andreas@visena.com>

View thread View on postgr.es
From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-general@lists.postgresql.org
Date: 2024-05-24T15:51:59Z
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@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com>
 <https://www.visena.com>