From the course: Microsoft SQL Server 2022 Essential Training
Join today to access over 24,700 courses taught by industry experts.
Dynamic data masking - SQL Server Tutorial
From the course: Microsoft SQL Server 2022 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 allows users to query information out of the data tables, but it will apply various obfuscation techniques to make the data less readable. This is different from a 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 into a web form, where the individual characters that you type get replaced by an asterisk or a round 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 logged backed into the server with my personal Windows account, Adam. This gives me the system administrator privileges that I…
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.