This is more of a general question regarding network security which came up while I was brainstorming about SQL Databases on Azure.
When you configure a SQL Database you have the Option to make the resource accessible to all Services within Azure (see Screenshot SQL Database Config Options)
The documentation as well as several other sources say that this is a security risk. But I don't understand why. In my understanding everybody could "knock on the door" of the database coming from within Azure but I am still the only one with the credentials and therefor only I have access. So what is the potential risk? How bad is it really to allow all Azure Services to connect to my SQL Database? What is the worst case scenario?
Thank you.