dkoug Blog

Grant privileges on specific user in psql terminal

Postgresql -- Posted on July 17, 2017

Grant privileges on specific user in psql terminal

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;"