Скачать или смотреть Dynamic Data Masking in SQL server | Security feature in SQL server 2016 | Ms SQL

Want to hide sensitive information from unauthorized users ??
Then you are at the right place. Please do watch this video and learn how to do it.

::A security feature introduced in SQL Server 2016 that limits the access of unauthorized users to sensitive data.
:: This feature requires no coding effort from the application side or encrypting or applying any change to the actual data.
:: We have 4 main types of masking functions.

select * from customer

-** DEFAULT **--

alter table customer
alter column DOB date masked with (function = 'default()')

-** EMAIL **--
alter table customer
alter column email varchar(40) masked with (function = 'email()')


-** PARTIAL **--
alter table customer
alter column Card_number varchar (30) masked with (function = 'partial(2,"xx-xxxx-xxxx-",4)')


-** RANDOM **--
alter table customer
alter column mobile_no bigint masked with (function = 'random(111,999)')

-** To view masking function of a Column in a table **-
select OBJECT_NAME(OBJECT_ID) Tablename, name as Column_Name, is_masked, masking_function
from sys.masked_columns
order by Tablename, Column_Name


-** REMOVE MASKED on any Column **-
alter table customer
alter column first_name drop masked

-** Grant Access to view Masked Rows **-
Grant unmask to mask_test

-** Revoke Access to view Masked Rows **-
Revoke unmask to mask_test



Dynamic Data Masking(Ms Docs)
https://docs.microsoft.com/en-us/sql/...