Effective access control is essential for any database environment. In this session, Andreas Wolter, former program manager for security in SQL at Microsoft, who designed the authorization concept for SQL database in Fabric, will walk you in a demo-focused session through access control for SQL database in Fabric, to help you utilize it with maximum efficiency.
We will cover the difference between workspace and database roles and when to use each. The session will also dive into custom vs. built-in roles, the implications of using workspace roles in Fabric for SQL, and the introduction of granular permissions. Additionally, we’ll examine the various permission options for sharing a database in Fabric and highlight the differences in access control between Fabric, SQL Server, and Azure SQL. The goal is to align with the Principle of Least Privilege while ensuring that access control remains manageable.