Solved

Is Custom Data Masking possible?

  • 7 February 2023
  • 2 replies
  • 67 views

Badge

The following article describes several types of data masking:
 https://legacysupport.timextender.com/hc/en-us/articles/5463363539101-Dynamic-Data-Masking .
Does TimeXtender allow custom data masking as well? The example table shown at the top of this article is exactly what I am trying to accomplish. However, the article doesn't describe this type of masking, does it?
 

 

icon

Best answer by harishkm 7 February 2023, 19:57

View original

2 replies

Badge

Hello,

Custom masking is also allowed! Please follow the same steps as above and input your custom script. Here is documentation to further assist you:

https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver16

Userlevel 2
Badge +1

Hello @Jan Stroeve Thank you for your engagement in the community. 

You will be able to achieve the masking format you are looking for by tweaking the partial function in the masked column. Follow the steps in the same article and use partial function on the masked columns. 

partial (prefix, padding, suffix) 

Where: prefix is the starting number of characters to be revealed and suffix is the last number of characters to be revealed from the column value. Padding is the custom padding string in the middle.

 

We are able to achieve similar masking on phone number column as shown below. 

Please let us know if this works for you.

Reply