Dynamic Data Masking in SQL server | Security feature in SQL server 2016 | Ms SQL скачать в хорошем качестве

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/...