select * from information_schema.role_table_grants where grantee='YOUR_USER';
psql -l
PostgreSQL: catalogs
Advertising: