Row Level Security in Azure SQL Database

Sign in to queue

Description

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/

 

Embed

Download

The Discussion

  • User profile image
    Walter

    Excellent feature, can you share the slides?

  • User profile image
    Dwaine Gilmer

    This is a great presentation.

    I like the idea of binding the security to the schema and having the filtering logic on the database instead of the application. I like the write blocking too.

    I would like to have an idea of the cost in performance and compute and I/O.

Add Your 2 Cents