Search Postgresql Archives
system catalog permissions
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: system catalog permissions
- From: PropAAS DBA <dba@xxxxxxxxxxx>
- Date: Mon, 26 Feb 2018 16:11:23 -0700
- User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]