Postgres script to create read-write and read-only users

postgres_user_create.sql

/* Create Read-write PSQL user and DB */

CREATE DATABASE yourdbname;  
CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';  
GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;

\c yourdbname

GRANT ALL ON SCHEMA public TO youruser;
/* to grant db owner permission */
ALTER SCHEMA public OWNER TO youruser;


/* Create Read-only user for db $DB */

CREATE ROLE rouser WITH LOGIN PASSWORD 'yourpass' 
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION VALID UNTIL 'infinity';

\c $DB

GRANT CONNECT ON DATABASE $DB TO rouser;
GRANT USAGE ON SCHEMA public TO rouser;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO rouser;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO rouser;
REVOKE CREATE ON SCHEMA public FROM PUBLIC;

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO rouser;