View difference between Paste ID: <a href="/gshaYdMd">gshaYdMd</a> and <a href="/8jguP2qK">8jguP2qK</a>

REASSIGN OWNED BY postgres TO role_local;
1	-	REASSIGN OWNED BY postgres TO role_local;
1	+	GRANT ALL ON DATABASE db TO role_local;
2		GRANT ALL ON SCHEMA public TO role_local;
3		GRANT ALL ON ALL TABLES IN SCHEMA public TO role_local;
4		GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO role_local;
5		GRANT ALL ON ALL FUNCTIONS IN SCHEMA public TO role_local;
6
7		GRANT CONNECT ON DATABASE db TO role_remote;
8		GRANT USAGE ON SCHEMA public TO role_remote;
9		GRANT SELECT, INSERT, UPDATE ON ALL TABLES IN SCHEMA public TO role_remote;
10		GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO role_remote;
11		GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO role_remote;