How is SQL Change Automation helping you? Share to win DevOps books.

Running Post deployment Permissions script

Hi 
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.

Thanks
Sunil bindra

Answers

Sign In or Register to comment.