Home > mailing lists

prevent users from SELECT-ing from pg_roles/pg_database - Mailing list pgsql-general

From	Andreas Joseph Krogh
Subject	prevent users from SELECT-ing from pg_roles/pg_database
Date	May 24 18:51:59
Msg-id	VisenaEmail.66.54f51e587b38c9cc.18fab4b4eb6@origo-test01.app.internal.visena.net Whole thread Raw
Responses	Re: prevent users from SELECT-ing from pg_roles/pg_database Re: prevent users from SELECT-ing from pg_roles/pg_database
List	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

From: bruno vieira da silva
Date: 24 May, 13:31:18
Subject: Re: PG 12.2 ERROR: cannot freeze committed xmax

From: Muhammad Salahuddin Manzoor
Date: 24 May, 19:28:20
Subject: Re: prevent users from SELECT-ing from pg_roles/pg_database