Masked Dynamic Data

[Beka_Tsaava]

Hello,

I have got one question.

I want to use Dynamic data masking method for INT type column. I found that I can use the default() function.

for example:

/*MS Sql Server*/

CREATE TABLE [dbo].[Test](

[Id] [int] IDENTITY(1,1) NOT NULL,

[Payment] [money] MASKED WITH (FUNCTION = 'default()') NOT NULL

)

Unfortunately I need you. Instead of the default() function, I want to insert a function written by me, where I will have a logic written to only hide payments where Payment > 1000.00.

If you understand my question correctly, please share your opinion or even give me a sample of the script. How can I use the function I wrote and also put the above mentioned logic.

thanks

[#2]

@Beka_Tsaava , that's not possible to use a user defined function for masking. See column_definition (Transact-SQL) - SQL Server | Microsoft Learn,  => MASKED, you can use only the 4 predefined functions.

[#3]

@olafhelper  aha Okey. thank you very much

[#4]

Hi Beka,

To get more information on dynamic data masking in SQL Server, refer below website. The website is having in-depth information.

https://madesimplemssql.com/dynamic-data-masking/