In this demo you can learn how to implement row-level security using views.
- [Instructor] So in this demo what we're gonna look at…is using the pre-SQL Server 2016 model…for row-level security and I'm gonna do a couple of things.…So I'm gonna first, starting on line one,…create a table called orders,…this is just a basic orders table…we've used in the course before.…Then, we're gonna insert into that table three values…and our columns here are order ID,…customer ID, product, quantity, and sales price,…so we're gonna go ahead and insert that in.…The next thing we're gonna do, starting on line 16,…and this is kind of where the magic starts to this,…and you could potentially have to have…for each table you wanted to do row-level security on,…you actually will have to have one mapping table.…
So here I'm creating a table called SQL user mapping,…customer ID is varchar five,…and we're eventually gonna join that…to our base orders table.…On line 18, we're adding in SQL usernames,…so effectively we're putting in a row…for each customer ID that each of our SQL users can see,…and then we're putting in an active flag…
- Designing row-level security
- Using views to implement row-level security in SQL Server pre-2016
- Data encryption
- Configuring Always Encrypted
- Dynamic data masking
Skill Level Beginner
SQL Server 2017: Linux, Docker, and macOSwith Adam Wilbert1h 44m Intermediate
SQL Server Performance for Developerswith Joey D'Antoni3h 44m Intermediate
Course software1m 3s
1. Row-Level Security (RLS)
2. Encryption in SQL Server
3. Data Masking in SQL Server
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.