Help Center/ CloudTable Service/ User Guide/ ClickHouse User Guide/ ClickHouse Cluster Management/ ClickHouse User Management/ Creating a User
Updated on 2024-12-24 GMT+08:00
View PDF
Share

Creating a User

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

  • The admin, root, and default users are default users in the ClickHouse cluster and cannot be deleted.
  • Only the password of the admin user can be changed. The passwords of the root user and the default user 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. Click in the upper left corner to select a region.
  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.

    Figure 1 Creating a user
    Table 1 Parameter description

    Parameter

    Description

    User name

    Name of the new user.

    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 ($@!%*?&)

    Confirm Password

    Enter the password again.

  6. Check the parameters and click OK.

Deleting a User

  1. Log in to the CloudTable console.
  2. Click in the upper left corner to select a region.
  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.

    Figure 2 Deleting a user

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. Click in the upper left corner to select a region.
  3. Click Cluster Management and select the target cluster.
  4. Choose More < Update Password.
  5. Change the password and click OK.

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. Click in the upper left corner to select a region.
  3. Click Cluster Management and select the target cluster.
  4. Choose More < Assign Role.
  5. Select a role or multiple roles and click OK.
  • You can assign multiple roles to a user.
  • Roles can be defined by users.

Checking Permissions

  1. Log in to the CloudTable console.
  2. Click in the upper left corner to select a region.
  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

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