OceanBase logo

OceanBase

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

Product Overview
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

OceanBase

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

Product Overview
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.0Enterprise 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
  • 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 password
    • ODC homepage
    • Connect to a database
      • Manage 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
      • Snippets
    • 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 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 connection
      • Manage connections
    • Use the workspace
      • Overview
      • SQL window
      • Anonymous block window
      • Command-line window
      • Stored scripts
      • Snippets
    • 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 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
    • 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
  • FAQ

Download PDF

OceanBase Developer Center Documentation Product updates What is ODC? Benefits Architecture Features Limits Overview Install ODC Log on to ODC with an account 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 password ODC homepage Manage connections Overview System settings Overview SQL window Anonymous block window Command-line window Stored scripts Snippets Data mocking Asynchronous execution Recycle bin Overview Import tasks Export tasks Data mocking tasks Asynchronous tasks Session management Help Center Install ODC ODC homepage Create a connection Manage connections Overview SQL window Anonymous block window Command-line window Stored scripts Snippets Data mocking Asynchronous execution Recycle bin Overview Import tasks Export tasks Data mocking tasks Asynchronous tasks Session management Help center 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 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 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.0
iconOceanBase Developer Center
V 3.2.0Enterprise 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

Manage users

Last Updated:2023-06-25 03:26:45  Updated
share
What is on this page
Built-in user
Create a user
Manage users
Information of users
View a user
Edit a user

folded

share

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.Image 867

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

You can take the following steps to create a user:

  1. Specify the User Information .

    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 the following special characters:_ + @ # $ %.

    • 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 and must be 8 to 32 characters in length, containing at least two digits, two uppercase letters, two lowercase letters, and two of the following special characters:_ + @ # $ %. You can also click Random Password next to the field to generate a random password.

    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 a 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.

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.

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 some columns for you to filter users.

Column 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 the ODC.
Actions Indicates the actions you can take, including View , Edit , and Disable / Enable . You can click Disable / Enable to change the user status .

View a user

Click View in the Actions column. In the User Information panel, You can see the User Details and Related Resources tabs. The following table describes the information displayed on the tabs.

Tab Description
User Details * User creation information, including 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, including the creator, creation time, update time, 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 In the User Information panel, click Edit 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 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.

Previous topic

Overview
Last

Next topic

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