pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Seeing privileges on a schema
3+ messages / 2 participants
[nested] [flat]

* Seeing privileges on a schema
@ 2020-12-02 18:52 John Scalia <jayknowsunix@gmail.com>
  2020-12-02 19:00 ` Re: Seeing privileges on a schema Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: John Scalia @ 2020-12-02 18:52 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Seeing privileges on a schema
  2020-12-02 18:52 Seeing privileges on a schema John Scalia <jayknowsunix@gmail.com>
@ 2020-12-02 19:00 ` Tom Lane <tgl@sss.pgh.pa.us>
  2020-12-02 19:01   ` Re: Seeing privileges on a schema John Scalia <jayknowsunix@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2020-12-02 19:00 UTC (permalink / raw)
  To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin

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 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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Seeing privileges on a schema
  2020-12-02 18:52 Seeing privileges on a schema John Scalia <jayknowsunix@gmail.com>
  2020-12-02 19:00 ` Re: Seeing privileges on a schema Tom Lane <tgl@sss.pgh.pa.us>
@ 2020-12-02 19:01   ` John Scalia <jayknowsunix@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: John Scalia @ 2020-12-02 19:01 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: 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 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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2020-12-02 19:01 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-12-02 18:52 Seeing privileges on a schema John Scalia <jayknowsunix@gmail.com>
2020-12-02 19:00 ` Tom Lane <tgl@sss.pgh.pa.us>
2020-12-02 19:01   ` John Scalia <jayknowsunix@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox