Adding Managed Identity to SQL DB

Caution

Do not give owner permissions unless you really need to


CREATE USER [<app-name>] FROM EXTERNAL PROVIDER


ALTER ROLE db_datareader ADD MEMBER [<app-name>] 
ALTER ROLE db_datawriter ADD MEMBER [<app-name>]