From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Implement row-level security

Implement row-level security

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Implement row-level security

“

- Welcome back. This is lesson 6.7, implement row-level security. Up until now, we've talked about securing data at the column level or entire database, but now we're going to talk about a feature that secures data at the row-level. Row-level security is restricting who can see what data. It enables you to use group memberships or execution context to control who can see what data in a table at the row-level. The restriction logic is implemented and located in the database tier instead of the application layer, which makes the security more reliable. RLS is great in scenarios where you need to restrict who can see what data. For example, hospitals that restrict nurses to see only data for only their patients. So let's walk through an example of how to implement role level security. But let's lay the foundation first. Here I have a table of great employees. I also have created users for those employees and I've granted them select permissions on that table. So the first step to…

Contents