Question 3 Replies 163 Views × Close popover ChennaReddy Marreddy (ChennaReddyM) Accenture Accenture IN View Profile Send Message ChennaReddyM Member since 2013 20 posts Accenture Posted: February 18, 2016 Last activity: March 22, 2016 Posted: 18 Feb 2016 6:36 EST Last activity: 22 Mar 2016 7:24 EDT Closed SQL file generation while Deployment Hi All, Some times when we are doing deployments in higher environments, PEGA application will generate SQL scripts dynamically. How to prevent generation of SQL file while doing deployment. Like do we need any special Read / Write permissions to the schema users which we are suing as default schema? How can we solve this in case of ... 1. Single schema 2. Multi schema In case If we are using Command line tools for Deployment ? Can some one explain / provide some solution please? Data Integration System Administration × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 5 years ago Posted: 18 Feb 2016 7:26 EST × Close popover Kevin Zheng (KevinZheng_GCS) PEGA Director, Software Solutions Engineering Pegasystems Inc. US View Profile Send Message KevinZheng_GCS PEGA replied to ChennaReddyM this link has good explanation: https://pdn.pega.com/how-set-privileges-restrict-database-schema-changes-generated-process-commander Posted: 5 years ago Updated: 5 years ago Posted: 22 Mar 2016 5:20 EDT Updated: 22 Mar 2016 5:22 EDT × Close popover Vadym Turovskyi (VadymTurovskyi) Luxoft Luxoft UA View Profile Send Message VadymTurovskyi Luxoft replied to KevinZheng_GCS Kevin, will this work in case we are using command line tool? Also, maybe there's a way to not generate schema updates with command line tool at all? Accepted Solution Posted: 5 years ago Posted: 22 Mar 2016 7:24 EDT × Close popover Kevin Zheng (KevinZheng_GCS) PEGA Director, Software Solutions Engineering Pegasystems Inc. US View Profile Send Message KevinZheng_GCS PEGA replied to VadymTurovskyi it should work as long as your connecting user has the privileges mentioned in the article.