In order to use data from a dictionary, we must first load the data. Loads a file into the dictionary registry and assigns the dictionary a name to be used with other functions that require a dictionary name argument. It returns some random data from a dictionary.Įxample : mysql> select gen_dictionary('name') from aadhar_details Ģ rows in set (0.00 sec) gen_dictionary_load : To be valid, a dictionary file must contain at least one non-empty line. When a dictionary is loaded, it becomes part of the dictionary registry and is assigned a name to be used by other dictionary functions.ĭictionaries are loaded from plain text files containing one term per line.

Here the main advantage is we can load the dictionary files manually. This type of masking function is generating random data from the dictionary file. Masking Data for Customer Identification : Gen_rnd_us_phone() : returns a random U.S. Gen_rnd_pan() : returns a random payment card Primary Account Number. Gen_rnd_email() : returns a random email address in the domain. Gen_range() : returns a random integer selected from a given range. One of the nice functions of MySQL Data Masking is the ability to generate business-relevant datasets.īecause it is not always possible to test/simulate your application on your real dataset (indeed playing with the customer credit card or security social numbers is a very bad practice) this feature is very convenient. Generating Random Data with Specific Characteristics : Other numbers are replaced by “X” characters. The mask_ssn is a Social Security number that returns the number except for last 4 digits. string must be 11 characters long).Otherwise, this mask_pan_relaxed function did not check the string. The string must be a suitable length,(ie. The mask_pan_relaxed function will mask other characters except for first six digits and last 4 digits.Įxample : mask_pan_relaxed(photo) from aadhar_details If the argument is shorter than required, it is returned unchanged value.įor using this (mask_pan) function, We need a minimum of 5 characters.ġ row in set (0.00 sec) mask_pan_relaxed : | mask_pan(aadhar_number) | mask_pan(user_identity) | The mask span function it will mask all the values from passed argument except the last four-digit.Įxample : mask_pan(aadhar_number),mask_pan(user_identity) from aadhar_details

It will mask the data from the end of the row. It will mask the data from the beginning. In the above example, I have masked the (aadhar_number & status) column using mask_outer function. We can specify the number of strings that needs to be masked.Įxample : mask_outer(aadhar_number,3,2) as aadhar_number,mask_outer(status,2,2) as status from aadhar_details It will mask the left and right ends of a string. It will mask part of the data.įor using this mask_inner function you need minimum “ 3“ characters. In the above example, I have masked the (aadhar_number & status) column using mask_inner function. It will mask the interior part of a string, We can specify the number of strings that needs to be masked.Įxample : mask_inner(aadhar_number,1,2) as aadhar_number,mask_inner(status,2,0) as status from aadhar_details I have categorised those functions based on their usage. In MySQL 8.0 there were different types of masking functions are available. In MySQL 8.0 they have introduced 14 functions, 1) gen_blacklistġ4) mask_ssn Plugin Installation : plugin data_masking SONAME 'data_masking.so' Generation of random data, such as email addresses and payment card numbers. Transformation of existing data to mask it and remove identifying characteristics, for example, changing all digits of a credit card number but the last four to ‘X’ characters. This feature was introduced in MySQL 8.0.13 Enterprise Edition and it provides data masking and de-identification capabilities. In MySQL 8.0 Enterprise they have introduced a new security feature called data masking. For reference click here Column Level Data Masking. My colleague Prasanth written about column-level data masking. They introduced a new masking filter on the Maxscale 2.1 version. In MySQL community versions if you want to mask your data, You can go with a Maxscale load balancer. Data masking is one of the Key Features when comes to security. Data security plays a major role in current age.

Mysql generate random email