Seeing privileges on a schema

From: John Scalia <jayknowsunix(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Seeing privileges on a schema
Date: 2020-12-02 18:52:18
Message-ID: 19031B53-2D47-407B-9F85-60E303F2ABCA@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Jay

Sent from my iPad

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2020-12-02 19:00:11 Re: Seeing privileges on a schema
Previous Message Stephen Frost 2020-12-02 17:28:05 Re: pg_upgrade + replica servers + rsync --size-only is unsafe