SQL Server 2016 Row Level Security
In this episode of Data Exposed, Scott Welcomes not one, but TWO individuals to the show. Today, both Tommy Mullaney and Raul Garcia, Program Managers on the SQL Server SQL Security team, visit the show to talk about a new security feature in SQL Server 2016 called Row Level Security (RLS).
In the "Cloud First" era at Microsoft, RLS was first introduced in Azure SQL Database, and Data Exposed covered that on the show several months ago (https://channel9.msdn.com/Shows/Data-Exposed/Row-Level-Security-in-Azure-SQL-Database). RLS is feature that enables fine-grained control over access to rows in a table, allowing you to easily control which users can access which data with complete transparency to the application.
Both Tommy and Raul walk us through how this is implemented in SQL Server 2016, and they wrap up the episode by showing us an awesome demo of this great feature!