Grant privileges on specific user in psql terminal

Postgresql -- Posted on July 17, 2017

Grant privileges on specific user in psql terminal

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

Related Posts