1  CREATE USER reader WITH PASSWORD '...';
2  GRANT SELECT ON ALL TABLES IN SCHEMA public TO reader;