Currently, our deverloper group has started using DbUp and Octopus to do Continuous Integration on SQL Database Deployments. We have created a Domain user which will utilized to do the SQL Database deployment via Octopus server.
I wanted to know, what permissions should a Domain user should be granted for Continuous Integration process?
I don't want to give "SysAdmin" permission to this Domain user.
Do people have implemented above combination for there Continuous Integration of DB Deployment?