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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Joe Conway <mail(at)joeconway(dot)com>, richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com>, 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-05-01 04:09:57
Message-ID: a62a814c9eeb063129efff63d654909a77520b2b.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2023-04-28 at 09:25 -0400, Joe Conway wrote:
> On 4/26/23 13:50, richard coleman wrote:
> > Thanks for that.  It still seems rather weird that there isn't a more
> > straightforward way to get access to that information.
>
> Does this help?
>
> https://github.com/CrunchyData/crunchy_check_access
>
> For some examples of use:
> https://www.crunchydata.com/blog/postgresql-defaults-and-impact-on-security-part-1

There is also pg_permissions:
https://github.com/cybertec-postgresql/pg_permissions

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2023-05-01 07:43:35 Re: pg_dump why no indicator of completion
Previous Message Ron 2023-05-01 03:28:27 Re: pg_dump why no indicator of completion