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

From Laurenz Albe
Subject Re: how to list privileges on the database object itself via SQL?
Date
Msg-id a62a814c9eeb063129efff63d654909a77520b2b.camel@cybertec.at
Whole thread Raw
In response to Re: how to list privileges on the database object itself via SQL?  (Joe Conway <mail@joeconway.com>)
List 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



pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: pg_dump why no indicator of completion
Next
From: Holger Jakobs
Date:
Subject: Re: pg_dump why no indicator of completion