DB permissions required

• 
  Use Windows authenticator and run the release or deploy it I mean. When you come across the error showing the profile or account you are using has failed to login, contact your DBA. Provide him with the details and let him know what are you trying to do. He will have your profile/account access be granted and hence, you can see a success in your deployment.
  

  mkumar January 16, 2020 15:54

  - 0 +
• 
  I already did, and the DBA is asking me the permissions that need to be granted.

  sasankj January 16, 2020 15:56

  - 0 +
• 
  Ask him to grant the account/profile (example d2rddb) access to the server and the database as well [for that profile/account]
  
  

  mkumar January 16, 2020 15:58

  - 0 +
• 
  Also, do you know what type of output are we looking for? I got the access and it was a success. Now what would be the next step? I tried executing a non-destructive script and deployment was a success. How do I conclude the output? where do I check the output? I am trying to perform CICD operation for the data scripts. Will the DBA have to check manually to see the script is being executed on the server or something?
  

  mkumar January 16, 2020 16:01

  - 0 +
• 

  mkumar said:

  Ask him to grant the account/profile (example d2rddb) access to the server and the database as well [for that profile/account]
  
  

  I am not quite sure about this permissions? Is it db_owner?

  sasankj January 16, 2020 16:21

  - 0 +
• 

  sasankj said:

  mkumar said:

  Ask him to grant the account/profile (example d2rddb) access to the server and the database as well [for that profile/account]
  
  

  I am not quite sure about this permissions? Is it db_owner?

  Ask DB lead who controls the permissions. Generally they are limited to the DB team and Dev team who work on the database part. If there is no dedicated DevOps team then it is the DBA who handles all the permissions. They will have to provide you with access for the profile you want to use or give you a service account where you can test the scripts
  

  mkumar January 16, 2020 16:24

  - 0 +
• 

  Hello @sasankj ,
  

  
  

  Thanks for your query regarding SQL Change Automation. The permissions required varies case to case and depends on the objects in the database and what you're trying to deploy.
  

  
  

  You can reference the documentation below which gives some recommendations:

  
  

  https://documentation.red-gate.com/sc/getting-started/requirements/permissions-required-to-use-sql-compare

  
  

  I hope this is helpful. Please let me know if you have any further questions.
  

  
  

  Kind regards,
  

  
  

  Pete Ruiz
  

  Product Support Engineer
  

  Pete_Ruiz January 17, 2020 20:02

  - 0 +

Add comment

Please sign in to leave a comment.