psql mydatabase -c "GRANT ALL ON ALL TABLES IN SCHEMA public to dbuser;" psql mydatabase -c "GRANT ALL ON ALL SEQUENCES IN SCHEMA public to dbuser;" psql mydatabase -c "GRANT ALL ON ALL FUNCTIONS IN SCHEMA public to dbuser;"