Re: prevent users from SELECT-ing from pg_roles/pg_database

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: