Permission requirement

duongthaihaduongthaiha Posts: 6 New member
in ReadyRoll
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:
· Share on Twitter

Answers

  • dnlnlndnlnln Posts: 234 Gold 2
    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
    · Share on Twitter
Sign In or Register to comment.