Row level security in SQL Server 2016

Posted on Posted in Database, Development, Script, Security, T-SQL

sql_securityWith the release of SQL Server 2016 comes many great new features. One of these is the implementation of row level security in the database engine.

This blogpost will cover the aspects of this new feature – including:

  • Setup
  • Best practice
  • Performance
  • Possible security leaks

Introduction

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/

Leave a Reply

Your email address will not be published. Required fields are marked *