Re: how to list privileges on the database object itself via SQL? - Mailing list pgsql-admin

From richard coleman
Subject Re: how to list privileges on the database object itself via SQL?
Date
Msg-id CAGA3vBvjUiUb+O-UWYU8VNrrPrLrwz+KOg3zqwiWTAAkTChX_A@mail.gmail.com
Whole thread Raw
In response to Re: how to list privileges on the database object itself via SQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: how to list privileges on the database object itself via SQL?
Re: how to list privileges on the database object itself via SQL?
List pgsql-admin
Tom, 

Thanks, but no.  I am looking for the SQL statement.

I very rarely venture into psql, unless it's to run an SQL code block from the terminal.
Is there an SQL way to do this?

Thanks again, 
rik.

On Wed, Apr 26, 2023 at 12:40 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
richard coleman <rcoleman.ascentgl@gmail.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

pgsql-admin by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: how to list privileges on the database object itself via SQL?
Next
From: Tom Lane
Date:
Subject: Re: how to list privileges on the database object itself via SQL?