Re: Permissions for information_schema - Mailing list pgsql-general

From Susan Hurst
Subject Re: Permissions for information_schema
Date
Msg-id cb5326cec9951e04e8e93e6e2db90511@mail.brookhurstdata.net
Whole thread Raw
In response to Re: Permissions for information_schema  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general

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.
 

pgsql-general by date:

Previous
From: Mark Fletcher
Date:
Subject: Re: schema change tracking
Next
From: Ron
Date:
Subject: Re: Upgrading 9.1.17 to which version?