Software working with Azure SQL Database
When develop software working with Azure SQL database, some special considerations needs to be taken into account.
Connection string
With standard SQL Server, if the connection didn’t specify a database name in your connection string, the connection default to master database. Unless specifically denyed access, a valid login with connection permission can connect to master database and be able to see the full list of database names on the connected instance, even if they don’t have permission to access those databases.
Posted by John Liu Tuesday, November 9, 2021