당신의 스타트업을 성장시킬 준비가 되셨나요? 🚀 스타트업 프로그램을 신청하고, 파격적인 무료 혜택을 받아보세요!

DAC

How to Apply Data Masking Policies

November 29, 2024

Curious?
Reveal the Magic!

Please fill out the form to unlock your exclusive content!

QueryPie values your privacy. Please check out our Terms & Privacy Policy.

Overview

In an organization, sensitive data like personal or confidential information can be protected by configuring policies that mask such data upon retrieval. Using the Data Masking menu, you can create and manage policies by selecting the target connection and defining rules to apply masking patterns to specific columns.

Creating a Data Masking Policy

STEP 1 Navigate to the Data Masking menu and click the Create Policy button. Enter the following details:

  • Policy Name: A unique name to identify the policy.
  • Target Connection: The database connection to which the policy will apply.

STEP 2 After saving the policy, select the created policy and click the Add Rule List button to define rules. Provide the following details for each rule:

  • Database Name: Specify the database. This is required.
  • Table Name: Specify the table. This is required.
  • Column Name: Specify the column. This is required.
  • Masking Pattern: Add one or more masking patterns to be applied to the specified column.
    • Use the Masking Pattern menu to create masking patterns via regular expressions. This menu also provides over 20 predefined patterns for masking personal and sensitive data.
  • Use the Allowed Users field to specify users or groups exempt from the masking rule.
    • Users or groups added to Allowed Users will be able to view unmasked data for the specified columns.

※ If a user who is not listed in Allowed Users queries data covered by a Data Masking Policy, the data will appear masked based on the applied pattern.

  • For example, email addresses might appear as *****@gmail.com depending on the masking pattern applied.

3 Minutes to Wow !

3 QueryPie, !

Take a Virtual Tour