From the course: Microsoft SQL Server 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Dynamic data masking - SQL Server Tutorial
From the course: Microsoft SQL Server 2019 Essential Training
Dynamic data masking
- [Instructor] Dynamic data masking is another feature of SQL Server that helps protect the security of your data. When enabled, it'll allow users to query information out of the data tables, but it'll apply various obfuscation techniques to make the data less readable. This is different from full encryption in that the values are masked on the SQL Server side before being sent to the user. You've probably seen this technique applied when you type in your password on a web form where the individual characters that you type get replaced by an asterisk or a bullet character on the screen. Dynamic data masking is applied on specific columns in a data table. In order to edit the table's design, you need to have the correct permissions to run alter table statements. So I've gone ahead and re-logged back in to my original Windows user account. This will give me the correct permissions that I need in order to make the following changes. First, let's go ahead and review the data from the…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.