Competition: What’s your favorite Redgate tool? Enter now.

Permission requirement

Hi
We have one user using SQL Authentication for deployment with VSTS. Is there defined permission requirement for that user used for deployment please? We have tried db_owner on Target Database however still lacking permission.
Thank you very much
Tagged:

Answers

  • Thank you for your question and sorry to hear you're running into a problem with your deployment.

    Granting the db_owner role on the user within the db should be sufficient to deploy to an existing database. Would you mind posting the part of the build log that is raising the error so we can investigate further?
    Daniel Nolan
    Product Manager
    Redgate Software
Sign In or Register to comment.