Assigning dbo.owner permissions to a SPN in terraform

Viewed 56

I am trying to app and SPN (that the pipeline runs on) as dbo.owner on a sql database that terraform provisions.

I have created the MSI (Managed Service Identity) on the SQL Server by :

 identity {
    type = "SystemAssigned"
  }

In the SQL block.

So I need terraform to use this MSI to assign a very simple t-sql statement like :

ALTER ROLE [dbo.owner] etc

I have also found this 3rd party terraform resource here

I am just wandering if anyone has put all this together.. Thx

0 Answers
Related