Re: Permissions for information_schema

From: Susan Hurst <susan(dot)hurst(at)brookhurstdata(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Permissions for information_schema
Date: 2019-05-16 17:18:10
Message-ID: cb5326cec9951e04e8e93e6e2db90511@mail.brookhurstdata.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The objects are granted SELECT to PUBLIC.

---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan(dot)hurst(at)brookhurstdata(dot)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(dot)hurst(at)brookhurstdata(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-05-16 17:20:44 Re: Upgrading 9.1.17 to which version?
Previous Message Mark Fletcher 2019-05-16 17:06:17 Re: schema change tracking