Advanced
Тема интерфейса

Creating a User

This section describes how to add and delete users, view user permissions, assign user roles, and change user passwords.

Note
  • The admin, root, and default users are default users in the ClickHouse cluster and cannot be deleted.
  • Only the passwords of users in the user list can be changed. The passwords of the root user and default users cannot be changed.
  • Users and roles cannot be created for a single node in a cluster.
  • Grant user A permission to operate on table B. Before deleting table B, user A must manually revoke this permission. If not, user A will retain the same operation permission on any new table B created by user C.

Creating a User

  1. Log in to the CloudTable console.
  2. Select a region in the upper left corner.
  3. Click Cluster Management on the left. The current cluster list is displayed.
  4. Locate the cluster to be operated and click Cluster Name > User Management. The User Management page is displayed.
  5. Click Create User in the upper left corner of the page. The Create User dialog box is displayed.

    Table 1 Parameter description

    Parameter

    Description

    User name

    The username must start with a letter.

    Password

    Password of the new user.

    NOTE:

    The password must:

    • Contain 8 to 16 characters.
    • Contain at least four of the following: uppercase letters, lowercase letters, digits, and special characters ($@!%*?&)
    • The password cannot be the username or the username spelled backwards.

    Confirm Password

    Enter the password again.

  6. Check the parameters and click OK.

Deleting a User

  1. Log in to the CloudTable console.
  2. Select a region in the upper left corner.
  3. Click Cluster Management and select the target cluster.
  4. Select the user to be deleted and click Delete. The deletion confirmation page is displayed.
  5. Click Yes to delete the user.
Note

Before deleting a user, make sure that it is not needed anymore. The deletion operation is irreversible. Even if an account with the same name is added immediately after the deletion, the permission may be different from that of the deleted one.

Changing the Password

  1. Log in to the CloudTable console.
  2. Select a region in the upper left corner.
  3. Click Cluster Management and select the target cluster.
  4. Choose More < Update Password.
  5. Change the password and click OK.
Note

The password of an existing account cannot be viewed. If you forget the password, you can reset the password.

Assigning Roles for a User

  1. Log in to the CloudTable console.
  2. Select a region in the upper left corner.
  3. Click Cluster Management and select the target cluster.
  4. Choose More < Assign Role.
  5. Select a role or multiple roles and click OK.
Note
  • You can assign multiple roles to a user.
  • Roles can be defined by users.

Checking Permissions

  1. Log in to the CloudTable console.
  2. Select a region in the upper left corner.
  3. Click Cluster Management and select the target cluster.
  4. Click Permission in the Operation column.
Table 2 Parameters

Parameter

Description

Username

Name of the new user.

Global Permission

Permissions such as query, insertion, modification, creation, and deletion.

Each Level Permission

  • Database and Table: created databases and tables
  • High-risk Permission: table creation and deletion permissions
  • Common Permission: query, insertion, and modification permissions
Note

The operation rights of an account on the database can be viewed.