On 5/16/19 9:50 AM, Susan Hurst wrote:
What are the correct permissions to give to a role so that all objects
in the information_schema (and pg_catalog) are visible to a user?
As example:
https://www.postgresql.org/docs/11/infoschema-tables.html
"... Only those tables and views are shown that
The objects are granted SELECT to PUBLIC.
---
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan.hu...@brookhurstdata.com
Mobile: 314-486-3261
On 2019-05-16 11:53, David G. Johnston wrote:
> On Thu, May 16, 2019 at 9:50 AM Susan
On Thu, May 16, 2019 at 9:50 AM Susan Hurst
wrote:
> What are the correct permissions to give to a role so that all objects
> in the information_schema (and pg_catalog) are visible to a user?
>
Have you determined that using the underlying pg_catalog schema is not
viable.
David J.
What are the correct permissions to give to a role so that all objects
in the information_schema (and pg_catalog) are visible to a user?
Permissions seem to make a difference but I don't know which adjustments
to make without causing unintended consequences. We revoked select on
all tables and
