Create ReadOnly Users in PostgreSQL

CREATE ROLE read_only_role; GRANT CONNECT ON DATABASE postgres TO read_only_role; GRANT USAGE ON SCHEMA public TO read_only_role; GRANT SELECT ON ALL TABLES IN SCHEMA public TO read_only_role; GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO read_only_role; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO read_only_role;

CREATE USER news_readonly_sa WITH PASSWORD '5hTu6B4YabGQCKsY'; GRANT read_only_role TO news_readonly_sa;