Unleashing the Power of Access Control of the SQL Engine

Andreas Wolter

Access control is a fundamental aspect of securing a database system, especially when storing high-value data. On the other hand, navigating a rich permission system such as the one offered by SQL Server and Azure SQL can be overwhelming even for the most seasoned DBA. In this session, Andreas Wolter, Program Manager and long-time expert for access control in SQL Server, will explore the authorization capabilities of SQL Server/Azure SQL, explain the value of industry best practices such as “Role separation” and “Principle of Least Privilege”, and share insights from his many years working directly with customers.

Discover some of the hidden gems that can help you implement access control policies that are effective for a wide range of workloads. Finally, you will learn how external governance policies through Microsoft Purview can be a valuable addition to your access control strategy.