Question3Replies159Views ChennaReddyM Member since 2013 20 posts Accenture Posted: February 18, 2016Last activity: March 22, 2016 Closed SQL file generation while DeploymentHi 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 popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post 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: 4 years agoKevinZheng_GCS PEGA replied to ChennaReddyMthis link has good explanation: https://pdn.pega.com/how-set-privileges-restrict-database-schema-changes-generated-process-commander Posted: 4 years agoUpdated: 4 years agoVadymTurovskyi Luxoft replied to KevinZheng_GCSKevin,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: 4 years agoKevinZheng_GCS PEGA replied to VadymTurovskyiit should work as long as your connecting user has the privileges mentioned in the article.