How Masking Function works with MyDiamo

Home / Database Encryption Solution / How Masking Function works with MyDiamo

There are many functions in MyDiamo which is useful to users— one o f them being the masking function. It enables users to select how the encrypted data can be shown to whom without any decrypting privileges while still encrypting the data. Below is the step-by-step on how to use MyDiamo’s masking function.

First, we need to create a table on MySQL. The table name is “mydiamo1” and is created on the “test” database. The user is “root”. We will insert four records on the table.

blog_mask1

Now we need to start MyDiamo CLI and create a policy. After that we will configure the column-level encryption settings, and set encryption privilege for the column “address”. This step can be seen by referring to the operation guide.

blog_mask2

After that we need to encrypt the column “address” on MySQL.

blog_mask3

Now, on MyDiamo CLI, we have to set the environment on how we want the encrypted data to look like: masking, empty data, error, or raw data.

By applying “masking”, the encrypted column will be shown like the image below.

blog_mask4 blog_mask5

By applying “empty data”, the encrypted column will be shown like the image below.

blog_mask6 blog_mask7

By applying “error”, the encrypted column will be shown like the image below.

blog_mask10 blog_mask11

By applying “raw data”, the encrypted column will be shown like the image below.

blog_mask12 blog_mask13

This is how users can use the masking function for MyDiamo. There are also many other features of MyDiamo that can benefit users in protecting their data.

MyDiamo
MyDiamo
Comprehensive encryption security for open source databases. We provide transparent and column-level encryption, key management, and access control and auditing for MySQL, MariaDB, and PerconaDB.
Related Posts