SUPERUSER has access to create tables in public 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;