Re: Seeing privileges on a schema

From: John Scalia <jayknowsunix(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Seeing privileges on a schema
Date: 2020-12-02 19:01:42
Message-ID: 575F6ED5-BDE7-4944-94F0-F32CDC735C15@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks, I didn’t realize that.

Sent from my iPad

> On Dec 2, 2020, at 2:00 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> John Scalia <jayknowsunix(at)gmail(dot)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 usage on 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Atul Kumar 2020-12-03 08:49:24 time taking deletion on large tables
Previous Message Tom Lane 2020-12-02 19:00:11 Re: Seeing privileges on a schema