Re: Permissions for information_schema

The objects are granted SELECT to PUBLIC.

---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan.hurst@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 Hurst <susan.hurst@brookhurstdata.com> 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.