Hi,
We currently run the OSS version via an Azure App Service connecting to an Azure SQL database. This was setup initially a few years back from the deployment script. This connects to the database via the fhirAdmin user. We would like to change this to connect to the database via Entra ID, specifically the managed identify of the app service. Is it documented anywhere (I can't find it) what the minimal permissions for the managed identity sql user is? Note - we do not do schema updates via the app service (we use the dotnet tool for this).
Thanks,
Reuben
Hi,
We currently run the OSS version via an Azure App Service connecting to an Azure SQL database. This was setup initially a few years back from the deployment script. This connects to the database via the fhirAdmin user. We would like to change this to connect to the database via Entra ID, specifically the managed identify of the app service. Is it documented anywhere (I can't find it) what the minimal permissions for the managed identity sql user is? Note - we do not do schema updates via the app service (we use the dotnet tool for this).
Thanks,
Reuben