Holger,
Thanks, that looks very good.
rik.
On Wed, Apr 26, 2023 at 2:23 PM Holger Jakobs <holger(at)jakobs(dot)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
>
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>