8.5.2.3 MySQL Enterprise Data Masking and De-Identification Component Function Reference

Table 8.46 MySQL Enterprise Data Masking and De-Identification Component Functions

Name	Description	Introduced
gen_blocklist()	Perform dictionary term replacement	8.0.33
gen_dictionary()	Return random term from dictionary	8.0.33
gen_range()	Generate random number within range	8.0.33
gen_rnd_canada_sin()	Generate random Canada Social Insurance Number	8.0.33
gen_rnd_email()	Generate random email address	8.0.33
gen_rnd_iban()	Generate random International Bank Account Number	8.0.33
gen_rnd_pan()	Generate random payment card Primary Account Number	8.0.33
gen_rnd_ssn()	Generate random US Social Security Number	8.0.33
gen_rnd_uk_nin()	Generate random United Kingdom National Insurance Number	8.0.33
gen_rnd_us_phone()	Generate random US phone number	8.0.33
gen_rnd_uuid()	Generate random Universally Unique Identifier	8.0.33
mask_canada_sin()	Mask Canada Social Insurance Number	8.0.33
mask_iban()	Mask International Bank Account Number	8.0.33
mask_inner()	Mask interior part of string	8.0.33
mask_outer()	Mask left and right parts of string	8.0.33
mask_pan()	Mask payment card Primary Account Number part of string	8.0.33
mask_pan_relaxed()	Mask payment card Primary Account Number part of string	8.0.33
mask_ssn()	Mask US Social Security Number	8.0.33
mask_uk_nin()	Mask United Kingdom National Insurance Number	8.0.33
mask_uuid()	Mask Universally Unique Identifier part of string	8.0.33
masking_dictionary_remove()	Remove dictionary from the database table	8.0.33
masking_dictionary_term_add()	Add new term to the dictionary	8.0.33
masking_dictionary_term_remove()	Remove existing term from the dictionary	8.0.33