This blogpost will cover the aspects of this new feature – including:
- Best practice
- Possible security leaks
The row level security feature was released earlier this year to Azure – following Microsoft’s cloud-first release concept.
A past big issue with the SQL Server engine was that in only understands tables and columns. Then you had to simulate security using secured views, stored procedures or table value functions. The problem here was to make sure that there were no way to bypass them.
With SQL Server 2016, this is no longer an issue.
Now the SQL Server engine handles the security policy in a central controlled area.
– read more at: http://www.sqlshack.com/row-level-security-in-sql-server-2016/