Hides parts of query results, such as all but the final four digits, from users without privileges, leaving the stored values untouched. Holders of the UNMASK permission see real data.
Read more: Microsoft Learn
In the Ultra Transcenders books
AZ-305SC-500DP-600DP-700DP-800
Each book explains Dynamic data masking in context, with comparison tables and the common traps.
Terms in this definition
- ALL
A DAX function that ignores any filters and gives back every row of a table or every value of the named columns. Used within CALCULATE, it works as a modifier that clears filters, although REMOVEFILTERS states that intent more clearly where it is available.
- VALUES
Returns in DAX the distinct column values, or table rows, still visible after filters are applied, sometimes with an extra blank entry. CALCULATE often takes the result as a table filter.
- UNMASK
Granting this SQL permission lets a user see real values that dynamic data masking would otherwise hide.
Related terms
- Custom string masking function
The
partial()function in dynamic data masking, which reveals a chosen number of characters at the start and end and fills the middle with custom padding. - default() masking function
Dynamic data masking option that hides a value completely, returning XXXX for text, zero for numeric types, 1900-01-01 for a date and 1900-01-01 00:00:00.0000 for a datetime.