How can we help you today? How can we help you today?

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?
Kattesang
0

Comments

3 comments

Sort by
  • Kendra_Little
    Hi there,

    To clarify your setup, which tool are you using to commit changes to your project? Are you using SQL Source Control to do this? Or SQL Change Automation?

    Thanks,
    Kendra
    Kendra_Little
    0
  • Kattesang
    I am using SQL Source Control to commit my changes to repository.
    Kattesang
    0
  • Kendra_Little
    Hello,

    Thank you for confirming. With SQL Source Control, I believe that the setting you are looking for is called "Ignore users' permissions and role memberships". You set this on the "Setup" tab under "Comparison Options."

    You may also find some additional information useful in this article on Source Controlling Your Database Permissions, which is specific to SQL Source Control. 

    Hope this helps,
    Kendra
    Kendra_Little
    0

Add comment

Please sign in to leave a comment.