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 http://blogs.technet.com/b/dataplatforminsider/archive/2015/10/28/sql-server-2016-community-technology-preview-3-0-is-available.aspx , 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 http://blog.jameyjohnston.com/ . Definitely check it out!
Full demo available here: http://blog.jameyjohnston.com/oil-gas-sql-server-security-demo/
More information about our PASS session is available here: http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=40409 .
