postgres create user that can create tables to a specific schema code example

Example 1: Database owner can't create new tables postgres

GRANT ALL ON schema public TO foo_user;

Example 2: Database owner can't create new tables postgres

REVOKE ALL ON schema public FROM public;