system catalog permissions - Mailing list pgsql-general

From PropAAS DBA
Subject system catalog permissions
Date
Msg-id 3a8e96fa-29c5-c761-bf87-b5c811fe8867@propaas.com
Whole thread Raw
Responses Re: system catalog permissions
Re: system catalog permissions
List 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



pgsql-general by date:

Previous
From: geoff hoffman
Date:
Subject: Re: Creating complex track changes database - challenge!
Next
From: "Joshua D. Drake"
Date:
Subject: Re: system catalog permissions