At our security session today at PASS Summit 2015, we were extremely fortunate to be joined by Jamey Johnston, a Data Scientist at a large independent Oil & Gas company, who shared a comprehensive demo using Row-Level Security, Dynamic Data Masking, and Always Encrypted to control access to oil well production data. Jamey’s demo showcases some of the latest functionality available today in SQL Server 2016 CTP3, and it demonstrates multiple approaches for implementing hierarchical access control using RLS. Best of all, you can download and play with the demo yourself over at Jamey’s blog. Definitely check it out!
Full demo available here: SQL Server 2016 Security Demo
More information about our PASS session is available here: Overview of Security Investments in SQL Server 2016 and Azure SQL Database [DBA-327-M].