From the course: SQL Databases in Microsoft Fabric
Join today to access over 25,500 courses taught by industry experts.
Security
From the course: SQL Databases in Microsoft Fabric
Security
- [Instructor] When it comes to security, it is probably best or easiest to compare SQL databases in Fabric to Azure SQL databases again. In in both cases, you can use a client tool of your choice, let's say SSMS, to connect them. In the case of Azure SQL database, that would be a firewall in between, which is not the case for Fabric SQL database. Fabric SQL DB solved this by leveraging existing features like Entra Conditional Access, which you can use to control which user gets to access your resources from where, et cetera, as well as Purview Protection Policies. This is possible because unlike Azure SQL DB, databases in Fabric do not support SQL users, but only Entra users, allowing them to entirely rely on Entra's builtin security features. Just as in Azure SQL DB, you can grant individual users or groups very granular permissions on your database objects. Just for clarity, since many of those settings will be in the underlying products, Entra and Purview, though, this is where…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.