Postgresql: create users w/ readonly (SELECT only)

psql create users with readonly access

> CREATE ROLE name_readonly WITH
    NOLOGIN
    NOSUPERUSER
    NOCREATEDB
    NOCREATEROLE
    INHERIT
    NOREPLICATION
    CONNECTION LIMIT -1;

> GRANT CONNECT ON DATABASE db_name TO name_readonly;
> GRANT USAGE ON SCHEMA schema_name TO name_readonly;
> GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO name_readonly;
> ALTER DEFAULT PRIVILEGES IN SCHEMA schema_name GRANT SELECT ON TABLES TO name_readonly;

> CREATE USER user_name WITH PASSWORD 'user_password';
> GRANT name_readonly TO user_name;