Create ReadOnly Users in PostgreSQL

1CREATE ROLE read_only_role;
2GRANT CONNECT ON DATABASE postgres TO read_only_role;
3GRANT USAGE ON SCHEMA public TO read_only_role;
4GRANT SELECT ON ALL TABLES IN SCHEMA public TO read_only_role;
5GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO read_only_role;
6ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO read_only_role;
7
8CREATE USER news_readonly_sa WITH PASSWORD '5hTu6B4YabGQCKsY';
9GRANT read_only_role TO news_readonly_sa;