What are the challenges you face when working across database platforms? Take the survey

Running Post deployment Permissions script

I am new to sql change automation. We are using Octopus to deploy databaseswith SQl Chnage Automation. We have some permissions to run on different environment need to run after deployment. The User is different for different environment and is already in Octopus Variable. Is there any way that if add my script in post-deplyment folder with variable in sql script, which can be transformed with Octopus variable and run after db deployment with correct user.

Sunil bindra


Sign In or Register to comment.