Row Level Security in Azure SQL Database
This week's episode of Data Exposed Scott welcomes Joachim Hammer, Principle Program Manager at Microsoft on the SQL Server team. Today, Joachim introduces us to a new feature just released to Azure SQL Database called Row Level Security (RLS). RLS is feature that enables fine-grained control over rows in a table, allowing you control over which users can access which data. Joachim first provides an overview of what RLS is, and then shows us "RLS in Thee Steps", which outlines the concepts of RLS under the convers. He then illustrates RLS with an awesome demo using a real-world scenario. This is a must-watch video.
Read more about RLS here:
Row-Level Security overview on MSDN: https://msdn.microsoft.com/library/7221fa4e-ca4a-4d5c-9f93-1b8a4af7b9e8.aspx
What's new in the latest SQL Database Update V12 (preview): https://azure.microsoft.com/en-us/documentation/articles/sql-database-preview-whats-new/