If you are on a version of SQL Server older than 2016, you have limited options to implement row-level security. One approach for doing this is to use views and a linked table.
- [Instructor] So, in realizing that not everyone…is on the latest releases,…whether it's SQL Server 2016, or 2017.…Some people have to work with legacy applications,…it's just the way the world works.…One of the things we're gonna talk about here in demo…is how you did row-level security before SQL Server 2016.…The first thing I'm gonna tell you…is that it involves writing additional code,…and making changes to your application,…so this is actually probably one of the hardest security…concepts in SQL Server before 2016.…There's no built in way to provide row-level security,…until that release.…
The concept behind row-level security…is that you're granted rights to a sub-set…of rows in the table,…and those are the only rows you are allowed to see.…This is a big concept from multi-tenant data bases,…and is very common.…What we can do, and it's a little bit tricky,…is we can create a table that maps to the user,…so it's a mapping view,…that the user would have permissions to,…and that view will handle all the access rights to the table…
- 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.