1

Is it possible to create MSSQL database user and then grant a database access ( owner privileges ) to this user using ARM templates?

Alexey Melezhik
  • 962
  • 9
  • 27

1 Answers1

1

Not in the current iteration of ARM. Here is what is supported with SQL server ARM templates.

If you're fixed on using db user/pass to talk to the database, try a powershell script as part of your CI/CD pipeline. But you could also look at Azure AD cert-based auth or Managed Service Identity (MSI) instead.

Josh
  • 4,009
  • 2
  • 31
  • 46
  • Just a note on ARM template support. It seems it is still not possible to create an MSI connected user using ARM alone. It still needs fiddling in the database after creation. The MSI link above explains as much as well. Here is another post: https://stackoverflow.com/questions/62581121/can-non-administrative-users-be-provisioned-in-azure-sql-via-an-arm-template – span Apr 19 '22 at 07:44