Grant privileges on specific user in psql terminal

Postgresql July 17, 2017 python

Grant privileges on specific user in psql terminal

python

1
2
3

psql databasename -c "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public to username;"
psql databasename -c "GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public to username;"
psql databasename -c "GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public to username;"