GRANT ALL ON DATABASE postgres TO johndoe;
GRANT ALL ON SCHEMA public to johndoe;

\c fOo

GRANT ALL ON SCHEMA public TO johndoe;