Implementing Row Level Security in SQL Server [DEV]
Database Developer, DBA, Developer
Since the early days of SQL Server, it has been possible to use basic security measures to allow (and disallow) user access to any object in a database, and even limit access to a given column. A more difficult task has been to limit access to the individual rows in a table. This has made application development more complex because whereas most every user may have access to a table like HR.Employee, not every employee will have access to every employee's data. In this session I will cover several techniques to limit access to rows, from methods that have existed since early versions of SQL Server, to the new Row Level Security feature in SQL Server 2016. If time permits, an overview of Dynamic Data Masking will be included, since it is a related technology.