system catalog permissions

Поиск
Список
Период
Сортировка
От PropAAS DBA
Тема system catalog permissions
Дата
Msg-id 3a8e96fa-29c5-c761-bf87-b5c811fe8867@propaas.com
обсуждение исходный текст
Ответы Re: system catalog permissions  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: system catalog permissions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: geoff hoffman
Дата:
Сообщение: Re: Creating complex track changes database - challenge!
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: system catalog permissions