Dimitris Kougioumtzis Blog About technology

Grant privileges on specific user in psql terminal

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

About

My name is Dimitris Kougioumtzis and i work as a Web developer at Rapidbounce Company

Elsewhere