I have user_1 who creates a set of tables in schema public. I want user_2 to be able to select & update those tables, even if user_1 creates new tables in the future.
I thought this was achieved by
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, INSERT, UPDATE ON tables TO user_2;
However, it doesn't seem to be working for new tables created by user_1