reader user on psql:

NOPE: https://tableplus.io/blog/2018/04/postgresql-how-to-create-read-only-user.html

https://gist.github.com/oinopion/4a207726edba8b99fd0be31cb28124d0

then, from the command line:

    sqlcarrots=> ALTER DEFAULT PRIVILEGES IN SCHEMA public
    sqlcarrots->    GRANT SELECT ON TABLES TO reader;

    ALTER DEFAULT PRIVILEGES