Re: Seeing privileges on a schema

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

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2020-12-02 19:01:42 Re: Seeing privileges on a schema
Previous Message John Scalia 2020-12-02 18:52:18 Seeing privileges on a schema