Configuring security in Azure SQL Database
In an earlier section, we learned about connecting to Azure SQL Database with ASP.NET Core code. In this section, we will learn about various ways to configure security in Azure SQL Database.
We will look at two main options. First, we will look into how to connect to Azure SQL using an identity and then we will look into firewall configuration.
Connecting to Azure SQL Server using an identity
In an earlier section, we connected to Azure SQL Server with a username and password, but Microsoft’s recommended option to connect to Azure SQL is using identities – a feature that allows services to interact with each other without credentials. There are two types of identities available in Azure. The first one is system-assigned and the second one is user-assigned. System-assigned identities are removed when you remove the associated resource, which means that if we are creating a system-assigned identity for an Azure app service...
