information schema

select * from information_schema.role_table_grants where grantee='YOUR_USER';

grantor grantee .../...

Relate

• psql -l

SELECT, GRANT SELECT ON, BETWEEN

PostgreSQL: catalogs