On Wed, Apr 26, 2023 at 2:23 PM Holger Jakobs <holger@jakobs.com> wrote:
Try this command:
with cte as (select oid, datname, (aclexplode(datacl)).* from pg_database where oid>1) select cte.oid, datname, grantor.rolname as grantorname, coalesce(grantee.rolname, 'public') as granteename, privilege_type, is_grantable from cte join pg_authid grantor on cte.grantor = grantor.oid left join pg_authid grantee on cte.grantee = grantee.oid