| From: | richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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 17:20:14 |
| Message-ID: | CAGA3vBvjUiUb+O-UWYU8VNrrPrLrwz+KOg3zqwiWTAAkTChX_A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-04-26 17:22:59 | Re: how to list privileges on the database object itself via SQL? |
| Previous Message | Erik Wienhold | 2023-04-26 17:17:11 | Re: how to list privileges on the database object itself via SQL? |