Managing Users

Depending on your account’s privileges, you may be able to add, edit, or delete users in your ClickHouse® cluster. The Users panel lists all the users, their access, where their accounts are defined, and their profiles:

Figure 1 - The Users View

In the display here, the lock icon next to the altinity and datadog user accounts mean that their access and privileges can’t be changed.

Clicking the button lets you add a new user:

Figure 2 - The User Details dialog

Here are the details of these fields:

Login | Password

The username and password. The passwords have to be at least 12 characters long, and they have to match. The OK button is disabled until the password fields are correct.

Databases

A comma-separated list of databases this user is allowed to access. If left blank, the user has access to all databases.

Profile

The user’s profile. See the Configuring Profiles page for details on working with profiles.

Access Management

If selected, this user will be able to create, delete, and modify user accounts via SQL statements. This is useful for users who may not have access to the ACM UI.

As you would expect, clicking the vertical dots icon next to a username lets you edit or delete that user. The edit dialog is identical to the User Details dialog shown in Figure 21 above. The delete dialog is straightforward:

Figure 3 - The Delete User dialog