In this demo you will see a sample process for implementing row-level security in SQL Server 2017.
- [Instructor] So let's demo real level security.…The first few things we're gonna do are…we're gonna create three users without logins.…And we're just doing this for the purposes of the demo.…This isn't a real scenario, but we're creating…these users without logins, so these'll just represent…three different users, a manager,…salesperson one and salesperson two.…The next thing we're gonna do,…starting on line seven, is create this table.…And we're just creating a table called Sales…with OrderID, SalesRep, Product, and quantity.…And then we're gonna insert some values into it.…
So, we're gonna insert…six sales records from lines 16 to 21.…And then here we're gonna do,…on line 23, select star from Sales,…to make sure we can see all the data.…And, as we see, we see all six sales records.…And we see that they're from two different sales reps.…So I'm gonna grant select on this table…to each of the users that we just created,…so they'll have permission to see the whole table.…And right now, if they looked,…they would see the whole 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.