From the course: SQL Server 2016: Administer a Database Infrastructure
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Configure row-level security - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Configure row-level security
- [Instructor] One of the new features added to SQL Server 2016 is support for row level security policies, or RLS. When enabled, row level security will actively control access to specific rows of data in a data table based on the characteristics of the user that's making the request. For instance, a regional sales manager will only see the records of transactions that occurred within their region, not the entire company. Access to row level data in a table is restricted by a security predicate defined as an inline table-valued function. Now, that sounds like a whole bunch of moving parts, so let's go ahead and see how to set it up. We'll start by using the WideWorldImporters database. Next, I want to take a look at the data that we're going to be using. I'll select everything from a table called Application.People. For this example, I'd like the HumanResources user to only be able to view the records for the people that are actually employees. We can find out who those people are by…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.