User Management

2026-03-06 07:02:42  Updated

Click Tenant Management in the left-side navigation pane. On the Tenant Management page, click the name of the tenant in the Tenant List. On the Overview page of the tenant, click User Management in the left-side navigation pane to go to the User Management page. This topic describes the information on the User Management page and the operations that you can perform on this page.

Create a user

On the User Management page, click Create User in the upper-right corner. On the Create Database User page, set the Username, Password, Global Privileges, and Database Privileges. After the settings are completed, click Submit.

Parameter Description
Username The username must meet the following requirements:
  • 2 to 64 characters in length
  • Must start with a lowercase letter, and can contain lowercase letters, digits, and underscores (_).
Password The password must meet the following requirements:
  • 8 to 32 characters in length
  • At least 2 characters from each of the following categories: digits (0-9), uppercase letters (A-Z), lowercase letters (a-z), and special characters (~!@#%^&*_-+=|(){}[]:;,.?/).
After the password is configured, you can click Copy Password to copy the password. Save the copied password for later use.
Confirm Password Enter the password again to confirm. If the two passwords are inconsistent, a message is displayed: The two new passwords are inconsistent. Please re-enter them..
Global Privileges (Optional) Select the privileges that the user can have from the drop-down list. The privileges apply to all databases. If no privileges are selected, the user has no privileges.
Database Privileges Set the privileges of the user for each database. The privileges apply to all targets in the specified database. The setting method is as follows:
  1. Select one or more databases from the left list. The left list displays all databases in the current cluster. If there are too many databases, you can search for the specified database in the search box in the left list.
  2. Click > in the middle. The selected databases are moved to the right list.
  3. Select the privileges that the user can have in the specified database from the right list. Click All in the upper-right corner of the corresponding database to grant all privileges to the user for the database.
  4. Repeat steps 1, 2, and 3 to set the privileges for different databases. If too many databases are moved to the right list, you can search for the specified database in the search box in the right list.
  5. To cancel the privileges of the user for the specified database, click Delete in the upper-right corner of the database in the right list to move the database back to the left list. You can also click Remove All in the upper-right corner of the right list, and then click OK in the pop-up window to move all databases in the right list back to the left list.

Lock a user

You can lock a user by using the switch icon in the Locked column. If the user is not locked, click the switch icon to lock the user. In the dialog box that appears, click OK. The locked user will be unable to log in. Proceed with caution. If the user is locked, click the switch icon to unlock the user. In the dialog box that appears, click OK. The unlocked user will be able to log in.

Change the password

Click the Change Password field in the Actions column. In the dialog box that appears, enter the New Password and Confirm Password. After you finish the entries, click OK to change the user's password.

Modify Permissions

Click the Modify Permissions field in the Actions column to modify the global and database permissions of the corresponding user. The modification steps are as follows:

  1. Select one or more databases from the left list box. The left list box displays all available databases in the current cluster. You can also search for a specific database in the left search box.

  2. Click the > button in the middle. The selected databases will be moved to the right list box.

  3. In the right list box, select the permissions that the user can have for the specified database. Click the All field in the top right corner of the corresponding database to grant the user all permissions for the current database.

  4. Repeat steps 1, 2, and 3 to set user permissions for different databases. If there are too many databases in the right list box, you can search for a specific database in the right search box.

  5. To cancel the user's permissions for a specified database, click the Delete field in the top right corner of the database in the right list box to move it back to the left list box. You can also click the Remove All field in the top right corner of the right list box, and then click OK in the pop-up window to move all databases in the right list box back to the left list box.

  6. After setting the permissions, click Submit to complete the modification.

Delete a User

Click the Delete field in the Actions column, enter delete in the pop-up window, and then click Delete to delete the corresponding user. Deleting a user will also delete all objects and data under the user. Proceed with caution.

Contact Us