Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In the Data Masking profile you configure the masking method you want to use, which UDR types and field you want to mask/unmask, and any masking method specific settings.

...

Creating a Data Masking Profile Using the Database Storage Method

To use the database storage method, you need to create a table to store the mappings between masked and unmasked data. It is important that there are unique indexes for both the masked and unmasked data since the masking method implementation depends on the database constraints to ensure consistency in the table data.

The example below shows what a definition with a single storage field in an Oracle database may be:

Info
titleExample - A definition with a single storage field in an Oracle database


Code Block
CREATE TABLE masking_info (
    unmasked NOT NULL,
    masked NOT NULL,
    CONSTRAINT masking_info_pk PRIMARY KEY (unmasked)
);
 
CREATE UNIQUE INDEX idx_masking_info_masked ON masking_info (masked);


...

  1. In the Fields tab, select the Hash option in the Masking Method drop-down-list.

    The Storage Fields section will then be greyed out.

  2. Click on the Add... button beneath the UDR Field Mappings section. 

    The Add UDR Field Mappings dialog opens.


  3. Click on the Browse... buttons and select which UDR type and field you want to add and click on the Add button. Then repeat this step for all the types and fields you want to add.

  4. When finished, click on the Close button to close the dialog.

  5. Click on the Hash tab to display the Hash specific settings:


  6. Either enter a key manually, or click on the Random button to generate a random key in the Salt field.

  7. Save the profile and you are done.


Scroll ignore
scroll-viewportfalse
scroll-pdftrue
scroll-officefalse
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmlfalse


Next: