What are the challenges you face when working across database platforms? Take the survey
Options

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

  • Options
    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.