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

Log in to the CloudTable console.
Select a region in the upper left corner.
Click Cluster Management on the left. The current cluster list is displayed.
Locate the cluster to be operated and click Cluster Name > User Management. The User Management page is displayed.

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.

Check the parameters and click OK.

Deleting a User

Log in to the CloudTable console.
Select a region in the upper left corner.
Click Cluster Management and select the target cluster.
Select the user to be deleted and click Delete. The deletion confirmation page is displayed.
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

Log in to the CloudTable console.
Select a region in the upper left corner.
Click Cluster Management and select the target cluster.
Choose More < Update Password.
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

Log in to the CloudTable console.
Select a region in the upper left corner.
Click Cluster Management and select the target cluster.
Choose More < Assign Role.
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

Log in to the CloudTable console.
Select a region in the upper left corner.
Click Cluster Management and select the target cluster.
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.

Parent topic: ClickHouse User Management

Предыдущая статья

ClickHouse User Management

Следующая статья

Using User Management Commands

Была ли эта статья полезна?

Поддержка Юридические документы