list all tables for which user or role has privileges

table_privileges.sql

SELECT 
    schemaname||'.'||tablename 
FROM 
    pg_tables 
WHERE 
    has_table_privilege (
        'user or role name',
        schemaname||'.'||tablename, 
        'select'
     ) 
AND 
    schemaname NOT IN ( 
        'pg_catalog',
        'information_schema'
     );