postgres-investigate-table-privileges.sql

SELECT
    c.relname,
    a.grantor::regrole,
    a.grantee::regrole,
    c.relowner::regrole,
    array_agg(a.privilege_type ORDER BY a.privilege_type) AS privileges
FROM
    pg_class c
    JOIN pg_namespace n ON c.relnamespace = n.oid
    LEFT JOIN aclexplode(c.relacl) AS a ON TRUE
WHERE
    n.nspname = 'public'
    AND c.relkind IN ('r', 'p')
GROUP BY
    1, 2, 3, 4
ORDER BY
    1, 2, 3, 4;