Postgres Pro
Downloads
Home   >   mailing lists

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

From Muhammad Salahuddin Manzoor
Subject Re: prevent users from SELECT-ing from pg_roles/pg_database
Date
Msg-id CAKD7CD=-RiQQq+Q-zC8cP5hmfG6icj1cUT0Ebx8a=gwyp=dR1w@mail.gmail.com
Whole thread Raw
In response to prevent users from SELECT-ing from pg_roles/pg_database  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-general
Tree view
Greetings,

To prevent a user or role from selecting data from certain system tables in PostgreSQL, you can revoke the default select permissions on those tables. Here’s how you can do it:

  1. Revoke SELECT permission on the system tables from the public role.
  2. Grant SELECT permission only to specific roles that need it.

Here’s a step-by-step guide on how to achieve this:


Salahuddin.

On Fri, 24 May 2024, 20:52 Andreas Joseph Krogh, <andreas@visena.com> wrote:

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
Attachment

pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: prevent users from SELECT-ing from pg_roles/pg_database
Next
From: Tom Lane
Date:
Subject: Re: prevent users from SELECT-ing from pg_roles/pg_database