Read only user in postgres database

read_only_user_in_postgres.sql

-- create a group
CREATE ROLE readaccess;

-- grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

-- grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

-- create user
CREATE USER user_name WITH PASSWORD 'secret_password';
GRANT readaccess TO user_name;

The gist is based on:

• https://gist.github.com/oinopion/4a207726edba8b99fd0be31cb28124d0
• https://tableplus.io/blog/2018/04/postgresql-how-to-create-read-only-user.html

The blog post:
https://pplonski.github.io/read-only-user-in-postgres/