We are developing with our SQL Server for Thinkwise on Azure.
We have various users as sf_developers. Unfortunately it is currently only possible to deploy changes in our (data) model when logged in as tsf_admin. Other users are not allowed to make changes to the application database. What do I need to do so that other sf_devolepers can also deploy their changes to the application database?
Related to this:
Currently I also have to create users for each application database. So also for all sf_developers so that they can test their own changes. Can this be automated in some way?
Best answer by Jasper
To create a database, a login must be one of the following:
- The server-level principal login
- The Azure AD administrator for the local Azure SQL Server
- A login that is a member of the