Row Level Security in Azure SQL Database

Play 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:

What's new in the latest SQL Database Update V12 (preview):




The Discussion

  • User profile image

    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.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.