Postgres Pro
Downloads
Home   >   mailing lists

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

From Joe Conway
Subject Re: how to list privileges on the database object itself via SQL?
Date
Msg-id 4bb118ef-23c6-46e1-3938-91b660ff6047@joeconway.com
Whole thread Raw
In response to Re: how to list privileges on the database object itself via SQL?  (richard coleman <rcoleman.ascentgl@gmail.com>)
Responses Re: how to list privileges on the database object itself via SQL?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view 
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

-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

pgsql-admin by date:

Previous
From: "Wetmore, Matthew (CTR)"
Date:
Subject: how to list privileges on the database object itself via SQL?
Next
From: richard coleman
Date:
Subject: Re: how to list privileges on the database object itself via SQL?