Users roles got cleared after deployement using SQL Change Automation:Release task in Azure DevOps

I am doing POC to understand the deployment of SQL scripts using SQL Change Automation Release task in Azure DevOps. In repository I have not checked-in the security folder (which having User & Role creation scripts). The target environment DB where I am deploying, having some set of users to access to that DB. Once deployment completed, User is available. But all the roles are revoked(For example db_reader, db_writer.....).

Is it mandatory to check-in all the security related scripts? Or do we have any option for not clearing those access? 


Sign In or Register to comment.