OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase Developer Center

V3.4.0Enterprise Edition
  • Document Overview
  • What's New
    • What's New
  • Overview
    • What is ODC?
    • Benefits
    • Architecture
    • Features
    • Limits
  • Quick Start
    • Overview
    • Install ODC
    • Log on to ODC with an account
    • Create a private connection
  • Tutorials
    • Tips on the SQL Console
    • Create a connection
    • Export data
    • Import data
    • Debug a stored procedure
    • View the performance of an SQL statement
  • User Guide (Web ODC)
    • Log on to ODC
      • Log on to ODC with an account
      • Change the password
    • ODC homepage
    • Connect to a database
      • Create a private connection
      • Manage private connections
    • Public resource management
      • Overview
      • Quick start
      • Resource permissions
        • Manage public connections
        • Manage resource groups
        • Manage roles
        • Manage users
      • Task process management
      • Manage operation records
      • Data desensitization management
      • System settings
    • Use the workspace
      • Overview
      • SQL window
      • Anonymous block window
      • Command-line window
      • Stored scripts
      • Snippet
    • Use tools
      • Data export and import
        • Overview
        • Export and import formats
        • Batch export and import
        • Single table export and import
      • Data mocking
      • Database changes
    • Recycle bin
    • View operation records
    • Task management
      • Overview
      • Import tasks
      • Export tasks
      • Data mocking tasks
      • Database change tasks
      • Permission application tasks
    • Session management
    • Database objects
      • Table objects
        • Overview
        • Create a table
        • Table list
        • Manage table attributes
        • Manage table data
      • View objects
        • Overview
        • Create a view
        • Manage views
      • Function objects
        • Overview
        • Create a function
        • Manage functions
      • Stored procedure objects
        • Overview
        • Create a stored procedure
        • Manage stored procedures
      • Sequence objects
        • Overview
        • Create a sequence
        • Manage sequences
      • Package objects
        • Overview
        • Create a program package
        • Manage program packages
      • Trigger objects
        • Overview
        • Create a trigger
        • Manage triggers
      • Type objects
        • Overview
        • Create a type
        • Manage types
      • Synonym objects
        • Overview
        • Create a synonym
        • Manage synonyms
    • Help center
  • User Guide (Client ODC)
    • Install ODC
    • ODC homepage
    • Connect to a database
      • Establish a connection
      • Manage connections
    • Use the workspace
      • Overview
      • SQL window
      • Anonymous block window
      • Command-line window
      • Stored scripts
      • Snippet
    • Use tools
      • Data export and import
        • Overview
        • Export and import formats
        • Batch export and import
        • Single table export and import
      • Data mocking
      • Asynchronous execution
    • Recycle bin
    • View operation records
    • Task management
      • Overview
      • Import tasks
      • Export tasks
      • Data mocking tasks
      • Database Change
    • Session management
    • Database objects
      • Table objects
        • Overview
        • Create a table
        • Table list
        • Manage table attributes
        • Manage table data
      • View objects
        • Overview
        • Create a view
        • Manage views
      • Function objects
        • Overview
        • Create a function
        • Manage functions
      • Stored procedure objects
        • Overview
        • Create a stored procedure
        • Manage stored procedures
      • Sequence objects
        • Overview
        • Create a sequence
        • Manage sequences
      • Package objects
        • Overview
        • Create a program package
        • Manage program packages
      • Trigger objects
        • Overview
        • Create a trigger
        • Manage triggers
      • Type objects
        • Overview
        • Create a type
        • Manage types
      • Synonym objects
        • Overview
        • Create a synonym
        • Manage synonyms
    • Help center
  • Deployment Guide
    • Deployment overview
    • Preparations before deployment
    • Deploy a single ODC node
      • Deployment process
      • Load and run an ODC image
    • Deploy ODC in high availability mode
      • Deployment process
      • Load and run an ODC image
      • Deploy SSL certificate
      • Deploy the NGINX proxy
      • Configure certificate trust
    • Deployment verification
  • Upgrade Guide
    • Overview
    • Preparations before upgrade
    • Upgrade single-node ODC
      • Upgrade process
      • Stop ODC of the earlier version
      • Load and run an ODC image
    • Upgrade high-availability
      • Upgrade process
      • Stop ODC of the earlier version
      • Load and run an ODC image
      • Upgrade NGINX image
    • Upgrade verification
    • Rollback after upgrade failed
  • FAQ

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase Developer Center
  3. V3.4.0

Data desensitization management

Last Updated:2026-09-04 08:15:22

Prerequisites
Overview
Create a desensitization rule
Manage desensitization rules
Desensitization Rules
View details of a desensitization rule
Edit a desensitization rule
Scenarios
Scenario 1: Enable data desensitization when you export data
Scenario 2: Enable data desensitization when you export a result set
Related topics

Prerequisites

You are granted the administrator role of the public resource console.

Overview

Data desensitization deforms sensitive privacy information, such as names, ID card numbers, mobile phone numbers, landline numbers, bank accounts, and email addresses. You can set data desensitization rules to protect sensitive privacy data.

This topic describes how to create and manage data desensitization rules in the public resource console in OceanBase Developer Center (ODC), and how to enable data desensitization strategies in ODC scenarios such as data export and result set export.

Data desensitization management - 1

Create a desensitization rule

Data desensitization management - 2

  1. Log on to ODC as the administrator, and go to the Public Resource Console page. In the left-side navigation pane, click Data Desensitization to go to the data desensitization management page.

  2. Click Create Desensitization Rule in the upper-right corner of the Desensitization Rules page. The Create Desensitization Rule panel appears.

  3. Specify the following parameters in the Create Desensitization Rule panel.

    Parameter
    Description
    Rule Name The name of the desensitization rule. The rule name can contain up to 48 characters in length and must be unique.
    Rule Status Select Enable or Disable.
    Rule Details Select a desensitization method so that sensitive characters are treated in the selected desensitization way.
    Desensitization Effect In the Test Data section, enter the data that you want to desensitize and click Verify Desensitization to view the desensitization result.
  4. After you specify the preceding information, click Create in the lower-right corner of the panel.

Manage desensitization rules

Created desensitization rules are displayed in a list on the Desensitization Rules page. On this page, you can perform the following operations:

  • Click the refresh icon to manually refresh the list.
  • Search for rules by using the search box in the upper-right corner of the list.

Desensitization Rules

The following table describes the columns contained in the list of desensitization rules.

Column
Description
Rule Name The name of the desensitization rule.
Desensitization Method The desensitization method selected when the rule was created. You can click the filter icon Filter to filter rules by desensitization method.
Rule Status The status of the desensitization rule. You can click the filter icon Filter to filter rules by status.
Updated At The latest time when the current desensitization rule was edited.
Actions The actions you can take. Valid values: View, Edit, Disable/Enable, and Delete.
- View: View the details of the current desensitization rule.
- Edit: Modify the details of the current desensitization rule.
- Disable: Disable the current desensitization rule.
- Delete: Delete the current desensitization rule.

View details of a desensitization rule

On the Desensitization Rules page, click View in the Actions column of the target rule. The Details of Desensitization Rule panel appears.

Data desensitization management - 3

Parameter
Description
Rule Name The name of the desensitization rule.
Desensitization Details The desensitization mode and segment selection.
Desensitization Effect In the Test Data section, enter the data that you want to desensitize and click Verify Desensitization to view the desensitization result.
Created By The user who created the current desensitization rule.
Created At The time when the current desensitization rule was created.
Updated At The latest time when the current desensitization rule was edited.

Edit a desensitization rule

Data desensitization management - 4

  1. On the Desensitization Rules page, click Edit in the Actions column of the target rule. The Edit Desensitization Rule panel appears.

  2. In the Edit Desensitization Rule panel, edit the rule parameters specified when the rule was created.

  3. After you edit the rule, click Save.

Scenarios

ODC allows you to enable data desensitization strategies in operations such as data export and result set export.

Scenario 1: Enable data desensitization when you export data

To enable a data desensitization strategy when you export the department table in ODC, perform the following steps:

  1. In the table list, right-click the department table and select Export from the context menu.

    Data desensitization management - 5

  2. In the Single Table Export panel, click Data Desensitization and select a data desensitization strategy.

    Data desensitization management - 6

  3. In the Single Table Export panel, select Manage Desensitization Strategies in the Data Desensitization drop-down list to add, sort, edit, or remove data desensitization strategies.

    Data desensitization management - 7

Scenario 2: Enable data desensitization when you export a result set

For more information about data exporting scenarios, see Batch export and import. To enable a data desensitization strategy when you download the result set returned by querying the department table in ODC, perform the following steps:

  1. In the result set, click the Download Data icon. In the Download Data panel, click Data Desensitization and select a data desensitization strategy.

    Data desensitization management - 8

  2. In the Download Data panel, click Manage Desensitization Strategies in the Data Desensitization drop-down list to add, sort, edit, or remove data desensitization strategies.

    Data desensitization management - 7

Related topics

  • Result tab
  • Batch export and import

Previous topic

Manage operation records
Last

Next topic

System settings
Next
on this page
Prerequisites
Overview
Create a desensitization rule
Manage desensitization rules
Desensitization Rules
View details of a desensitization rule
Edit a desensitization rule
Scenarios
Scenario 1: Enable data desensitization when you export data
Scenario 2: Enable data desensitization when you export a result set
Related topics