Create read-only SQL user

create-read-only-user.sql

-- create a read-only user
create role procore_ro;

-- allow the RO user to use the public schema
grant usage on schema public to procore_ro;

-- grant RO access on existing tables
grant select on all tables in schema public to procore_ro;

-- grant RO access on future tables
alter default privileges in schema public grant select on tables to procore_ro;