Diagram Raymond Raymond

Static and Dynamic Data Masking

event 2021-12-21 visibility 753 comment 0

Static data masking will replace sensitive data at rest and this operation is usually irreversible. This is usually used to build data warehouse or data mart for analytical purposes where sensitive data is not required; it is also used to generate DEV and TEST environments using production data.

Dynamic data masking will replace sensitive data in transition. The original data stored in the database will not be altered. When users issue query to retrieve the data, dynamic data masking process or engine will mask the data based on settings and users' access or roles. 


Dynamic data masking (Azure SQL Database)

comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

tag Tags
info Info
Image URL