Cacher is the code snippet organizer for pro developers

Force a user to have a default schema other than public:

ALTER USER <user> SET search_path=<schema>;

Grant permissions to a schema for a user:

GRANT ALL PRIVILEGES ON SCHEMA <schema> to <user>;