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

From: Joe Conway <mail(at)joeconway(dot)com>
To: 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-04-28 13:25:24
Message-ID: 4bb118ef-23c6-46e1-3938-91b660ff6047@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message richard coleman 2023-04-28 14:44:33 Re: how to list privileges on the database object itself via SQL?
Previous Message Wetmore, Matthew (CTR) 2023-04-28 13:06:14 how to list privileges on the database object itself via SQL?