system catalog permissions

From: PropAAS DBA <dba(at)propaas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: system catalog permissions
Date: 2018-02-26 23:11:23
Message-ID: 3a8e96fa-29c5-c761-bf87-b5c811fe8867@propaas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

All;

We have a client which is segmenting their multi-tenant cluster
(PostgreSQL 9.6) by schema, however if one of their clients connects via
pgadmin they see ALL schemas, even the ones they don't have access to
read. I assume pgadmin is pulling the list from the system catalogs.

What's the right/best practice approach? revoke all from public on
specific system catalog tables? Which tables?

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2018-02-26 23:43:49 Re: system catalog permissions
Previous Message geoff hoffman 2018-02-26 20:45:35 Re: Creating complex track changes database - challenge!