MySQL Enterprise Data Masking and De-Identification Function Descriptions • gen_rnd_ssn() • gen_rnd_us_phone() Random Data Dictionary-Based Functions The functions in this section manipulate dictionaries of terms and perform generation and masking operations based on them. Some of these functions require the  SUPER  privilege. When a dictionary is loaded, it becomes part of the dictionary registry and is assigned a name to be used by other dictionary functions. Dictionaries are loaded from plain text files containing one term per line. Empty lines are ignored. To be valid, a dictionary file must contain at least one nonempty line. • gen_blacklist( str ,  dictionary_name ,  replacement_dictionary_name ) Arguments: None. Return value: A random US phone number as a string. Example: Generates a random US phone number in  1-555- AAA - BBBB  format. The 555 area code is not used for legitimate phone numbers. Generates a random US Social Security number in  AAA - BB - CCCC  format. The  AAA  part is greater than 900 and the  BB  part is less than 70, which are characteristics not used for legitimate Social Security numbers. Arguments: None. Return value: A random Social Security number as a string. Example: +-----------------+-----------------+ mysql>  SELECT gen_rnd_ssn(); +---------------+ | gen_rnd_ssn() | +---------------+ | 951-26-0058 | +---------------+ mysql>  SELECT gen_rnd_us_phone(); +--------------------+ | gen_rnd_us_phone() | +--------------------+ | 1-555-682-5423 | +--------------------+ 1590