GRANT ALL ON DATABASE db TO role_local;
GRANT ALL ON SCHEMA public TO role_local;
GRANT ALL ON ALL TABLES IN SCHEMA public TO role_local;
GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO role_local;
GRANT ALL ON ALL FUNCTIONS IN SCHEMA public TO role_local;

GRANT CONNECT ON DATABASE db TO role_remote;
GRANT USAGE ON SCHEMA public TO role_remote;
GRANT SELECT, INSERT, UPDATE ON ALL TABLES IN SCHEMA public TO role_remote;
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO role_remote;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO role_remote;