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

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

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