OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Developer Center

V3.2.2Community Edition

  • OceanBase Developer Center Documentation
  • What's New
    • Product updates
  • 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
      • Member management
        • Manage users
        • Manage roles
      • Resource management
        • Manage public connections
        • Manage resource groups
      • 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
      • Asynchronous execution
    • Recycle bin
    • Task management
      • Overview
      • Import tasks
      • Export tasks
      • Data mocking tasks
      • Asynchronous 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
    • Revision note
  • User Guide (Client ODC)
    • Install ODC
    • ODC homepage
    • Connect to a database
      • Create 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
    • Task management
      • Overview
      • Import tasks
      • Export tasks
      • Data mocking tasks
      • Asynchronous 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
    • Revision note
  • 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
    • Revision note
  • Upgrade Guide
    • Overview
    • Preparation for 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
    • Revision note
  • FAQ

Download PDF

OceanBase Developer Center DocumentationProduct updates What is ODC? Benefits Architecture Features Limits Overview Install ODC Log on to ODC with an account Create a private connection Tips on the SQL Console Create a connection Export data Import data Debug a stored procedure View the performance of an SQL statement Log on to ODC with an account Change the password ODC homepage Create a private connection Manage private connections Overview System settings Overview SQL window Anonymous block window Command-line window Stored scripts Snippet Data mocking Asynchronous execution Recycle bin Overview Import tasks Export tasks Data mocking tasks Asynchronous tasks Session management Help center Revision note Install ODC ODC homepage Create a connection Manage connections Overview SQL window Anonymous block window Command-line window Stored scripts Snippet Data mocking Asynchronous execution Recycle bin Overview Import tasks Export tasks Data mocking tasks Asynchronous tasks Session management Help center Revision note Deployment overview Preparations before deployment Deployment process Load and run an ODC image Deployment process Load and run an ODC image Deploy SSL certificate Deploy the NGINX proxy Configure certificate trust Deployment verification Revision note Overview Preparation for upgrade Upgrade process Stop ODC of the earlier version Load and run an ODC image Upgrade process Stop ODC of the earlier version Load and run an ODC image Upgrade NGINX image Upgrade verification Rollback after upgrade failed Revision note FAQ
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogLive DemosTraining & Certification
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Developer Center
  3. V3.2.2
iconOceanBase Developer Center
V 3.2.2Community Edition
  • V 4.4.2
  • V 4.4.1
  • V 4.4.0
  • V 4.3.4
  • V 4.3.3
  • V 4.3.2
  • V 4.3.1
  • V 4.3.0
  • V 4.2.4
  • V 4.2.3
  • V 4.2.2
  • V 4.2.1
  • V 4.2.0
  • V 4.1.3 and earlier
Community Edition
  • V 4.1.0
  • V 4.0.0
  • V 3.3.2
  • V 3.2.2
Enterprise Edition
  • V 4.1.3
  • V 3.4.0

Manage users

Last Updated:2026-04-13 07:35:39  Updated
share
What is on this page
Overview
Built-in user
Create a user
Manage users
Information of users
View users
Edit a user

folded

share

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 Member Management > User Management 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

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

Image 868

To create a user, perform the following steps:

  1. Specify the user information.

    1. User information includes the following three parts:

      • Account : specifies 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 include . _ + @ # $ %

      • Name : specifies 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 : specifies 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 include . _ + @ # $ % 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.

    2. 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 Role Management page to create one.

  4. Optional. Specify the remarks.

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

  5. Submit the user information.

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

  6. Save the user information.

    In the dialog box that appears after you successfully create a user, 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.

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.

Parameter Description
Name Indicates the name of the user.
Account Indicates the account of the user.
Role Indicates the role assigned to the user.
Status Indicates the user status. Valid values: Enabled and Disabled .
Updated At Indicates the time of the last update of the user information.
Logon Time Indicates the time of the last logon to ODC.
Actions Indicates the actions you can take: 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 users

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

Parameter Description
User Details
  • User creation information, displays the information you specified when you created the user in fields such as Account , Name , Password , Role , and Remarks . The password is masked, and a Reset Password button is provided for you to change the logon password.
  • Operation information: displays information in fields such as Created By , Created At , Updated At , and Logon Time .
  • Delete a user: 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 recovered.
  • Related Resources This tab displays the names of the public connections that are accessible by the current user, the resource groups to which the public connections belong, and the access permissions for the resource groups.
    Edit You can click Edit in the lower-right corner of the User Information panel to go to the Edit User panel.

    Edit a user

    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 created the 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.

    Previous topic

    Overview
    Last

    Next topic

    Manage roles
    Next
    What is on this page
    Overview
    Built-in user
    Create a user
    Manage users
    Information of users
    View users
    Edit a user