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

V4.1.3Enterprise Edition
  • Document Overview
  • 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
        • Automatic authorization rules
      • 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
      • Partitioning plan
      • Database changes
      • Shadow table synchronization
      • SQL plan
    • Recycle bin
    • View operation records
    • Task management
      • Overview
      • Import tasks
      • Export tasks
      • Data mocking tasks
      • Database change tasks
      • Partitioning plan task
      • Permission application tasks
      • Shadow table synchronization tasks
      • SQL plan task
    • 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
      • Create a private 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
      • Shadow table synchronization
    • Recycle bin
    • View operation records
    • Task management
      • Overview
      • Import tasks
      • Export tasks
      • Data mocking tasks
      • Database Change
      • Shadow table synchronization 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
  • 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
  • Release Note
    • V4.1
      • ODC V4.1.3
      • ODC V4.1.1
      • ODC V4.1.2
      • ODC V4.1.0
    • V4.0
      • ODC V4.0.2
      • ODC V4.0.0
    • V3.4
      • ODC V3.4.0
    • V3.3
      • ODC V3.3.3
      • ODC V3.3.2
      • ODC V3.3.1
      • ODC V3.3.0
    • V3.2
      • ODC V3.2.3
      • ODC V3.2.2
      • ODC V3.2.1
      • ODC V3.2.0

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase Developer Center
  3. V4.1.3

Manage users

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

Overview
Built-in user
Create a user
Create a single user
Import multiple users at a time
Manage users
Information of users
View a user
Edit a user
Disable a user

Overview

Image 867

You can create users and manage user permissions on the User Management page of OceanBase Developer Center (ODC).

Log on to ODC as the administrator, and go to the Public Resource Console page. In the left-side navigation pane, choose Resource Permissions > User to display the User Management page on the right.

Built-in user

ODC has a built-in account admin that is automatically assigned the administrator role system_admin . The administrator account has all system permissions and has access to all public resources. You cannot edit, delete, or disable the account.

Create a user

Create a single user

Click Create User in the upper-right corner of the User Management page. The Create User panel appears.

Image 868

You can take the following steps to create a user:

  1. Specify the User Information .

    a. User information consists of the following three parts:

    • Account : the account used to log on to ODC. You must specify a unique account of 4 to 48 characters in length using letters, digits, and special characters. Special characters are . _ + @ # $ %

    • Name : the screen name to be displayed after the user logs on to ODC. The name must be specified and cannot exceed 110 characters in length.

    • Password : the password used to log on to ODC. The password must be specified. It must be 8 to 32 characters in length and contain at least two digits, two uppercase letters, two lowercase letters, and two special characters. Special characters are . _ + @ # $ % You can also click Random Password next to the field to generate a random password.

      Note
      You will be prompted to change the user password when you log on to ODC as a new user or after the administrator changes the user password. This hardens password security and prevents password leakage.

    b. ODC allows you to create multiple users at a time. Click Add User to specify the information for multiple users.

  2. Specify the Account Status .

    By default, the new user is created in the Enabled status. You can manually disable it. A disabled account is unable to log on.

  3. Assign roles to the new user.

    The roles are optional and you can assign multiple roles to a user. Click the field. In the drop-down list, select the roles that you want to assign to all users you just added. If no role is available, go to the Create Role page to create one.

  4. Specify the Remarks (optional).

    Enter the description in the field. The remarks are optional and cannot exceed 140 characters in length.

  5. Submit user information.

    In the lower-right corner of the panel, click Create to submit user information.

  6. Save user information.

    In the User Created dialog box appears after you click Create, you can view the information of all users you just created. In the dialog box, you can click Copy User Information and Download User Information to save the information of multiple users in local storage.

    This operation helps you quickly save user information when you create multiple users at a time.

Import multiple users at a time

ODC V4.1.2 and later allows you to import multiple users at a time by uploading a configuration file. Perform the following steps:

  1. In the upper-right corner of the User Management page, click Batch Import.

    batch user 1

  2. In the Batch Import panel, click Download Template, and specify the parameters of the users to be imported.

    batch user 2

    Parameter
    Description
    Account Required. The account used to log on to ODC. You must specify a unique account containing 4 to 48 characters in length using letters, digits, and special characters. Special characters include . _ + @ # $ %
    Name Required. The screen name to be displayed after the user logs on to ODC. The name cannot exceed 110 characters in length.
    Password Required. The password used to log on to ODC. The password must be 8 to 32 characters in length and contain at least two digits, two uppercase letters, two lowercase letters, and two special characters. Special characters include . _ + @ # $ %
    Account Status Required. Valid values: true and false.
    Role Optional. The name of the role created in ODC. Separate multiple role names with commas (,).
    Remarks Optional.

    batch user 3

  3. Click the file pool in the Batch Import panel to open the file explorer and select the file to be imported. You can also directly drag the file to the file pool to upload it.

  4. Click Import. After the users are imported, you can view them in the list of users.

    batch user 4

Manage users

On the User Management page, you can view the information of all users, and search for specific users by using the search box in the upper-right corner of the page. You can also view and manage the created users by using the buttons provided in the Actions column of the User Management page.

Information of users

The information of users is provided by columns, which are described in the following table. A filter is provided on top of columns for you to filter users.

Column
Description
Name The name of the user.
Account The account of the user.
Role The role of the user.
Status The user status. Valid values: Enabled and Disabled . You can click the filter icon Filter to filter the users by status.
Updated At The time of the last update of the user information. You can click Updated At to sort the users by update time in ascending or descending order.
Logon Time The time of the last logon to ODC. You can click Logon Time to sort the users by logon time in ascending or descending order.
Actions The actions you can take. Valid values: View , Edit , and Disable/Enable . You can click Disable/Enable to change the user status.
Note
After you log on to ODC, you cannot edit or disable your account.

View a user

View

Click View in the Actions column. In the User Information panel, you can see the User Details and Related Resources tabs.

Field
Description
User Details
  • User creation information: Account , Name , Password , Role , and Remarks that you specified when you created the user. The password is masked, and a Reset Password button is provided for you to change the logon password.
  • Operation information: Created By , Created At , Updated At , and Logon Time .
  • User deletion: You can click Delete User in the lower part of the tab to delete the user. After the user is deleted, the corresponding account cannot log on to ODC and its related data cannot be restored.
  • Related Resources This tab displays the names of the public connections that are accessible to the current user, the resource groups to which the public connections belong, and the access permissions for the resource groups.
    Edit In the User Information panel, click Edit to go to the Edit User panel.

    Edit a user

    edit

    Click Edit in the Actions column to go to the Edit User panel.

    In the Edit User panel, you can view all information specified when you create a user. After the user is created, the Account cannot be modified. However, you can modify the Name , Account Status , Roles , and Remarks , and can change the Password when viewing the user details page.

    Disable a user

    Click Disable in the Actions column of the user information list. In the message that appears, click Yes .

    Note

  • Disabled users cannot log on.
  • The account information of disabled users is retained. You can enable them again as needed.
  • Previous topic

    Manage roles
    Last

    Next topic

    Automatic authorization rules
    Next
    on this page
    Overview
    Built-in user
    Create a user
    Create a single user
    Import multiple users at a time
    Manage users
    Information of users
    View a user
    Edit a user
    Disable a user