Create APP CRUD user in Postgres

create_crud_user.sql

CREATE ROLE crud_user LOGIN PASSWORD 'thisissecretpassword';

ALTER DEFAULT PRIVILEGES IN SCHEMA public
   GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO crud_user;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO crud_user;


GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO crud_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
    GRANT USAGE, SELECT ON SEQUENCES TO crud_user;