Re: how to list privileges on the database object itself via SQL?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: how to list privileges on the database object itself via SQL?
Date: 2023-04-26 16:40:43
Message-ID: 870558.1682527243@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com> writes:
> This might sound like a silly question, but how would I list the privileges
> the various roles have on the database objects themselves?

Perhaps you are looking for psql's \l command? It's a bit
nonstandardly named (one would expect \d something)

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Erik Wienhold 2023-04-26 17:17:11 Re: how to list privileges on the database object itself via SQL?
Previous Message richard coleman 2023-04-26 16:34:21 how to list privileges on the database object itself via SQL?