Get user privileges postgres

console_1.sql

SELECT u.usename                             AS username,
       c.relname,
       n.nspname,
       pg_catalog.pg_table_is_visible(c.oid) as table_name,
       has_table_privilege(c.oid, 'SELECT')  as select_access,
       has_table_privilege(c.oid, 'INSERT')  as insert_access,
       has_table_privilege(c.oid, 'UPDATE')  as update_access,
       has_table_privilege(c.oid, 'DELETE')  as delete_access
FROM pg_catalog.pg_user u
         CROSS JOIN pg_catalog.pg_class c
         JOIN pg_namespace n on c.relnamespace = n.oid
WHERE c.relkind = 'r' -- Filter for only tables
  and u.usename = 'analytics-reader'
ORDER BY username, table_name;