Re: Seeing privileges on a schema - Mailing list pgsql-admin

From John Scalia
Subject Re: Seeing privileges on a schema
Date
Msg-id 575F6ED5-BDE7-4944-94F0-F32CDC735C15@gmail.com
Whole thread Raw
In response to Re: Seeing privileges on a schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Thanks, I didn’t realize that.

Sent from my iPad

> On Dec 2, 2020, at 2:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> John Scalia <jayknowsunix@gmail.com> writes:
>> In psql, I know that \dp or \dpp will show me which privileges are granted on tables, views, sequences, and
functions,what it doesn’t appear to be able to do, is show me what privileges are in the schema itself, like if I grant
usageon a schema. Then a \dpp doesn’t produce anything. Is there an easy way to see what privileges are on a schema? 
>
> \dn+ includes that.
>
>            regards, tom lane



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Seeing privileges on a schema
Next
From: Rob Emery
Date:
Subject: Re: pg_upgrade + replica servers + rsync --size-only is unsafe