Updating a user

If you have a ClickHouse® user, you can update the set of roles assigned to them.

Once created, you cannot edit the user name (spec.name) and cluster name (spec.cluster). To change the password, update the stringData.password value in the Kubernetes Secret referenced by the ClickhouseUser resource.

Using the CLIUsing the CLI

1. Get the list of users in the project: kubectl get clickhouseuser -n <project_name>.
2. Open the resource for editing: kubectl edit clickhouseuser <resource_name> -n <project_name>.
3. Change the composition of roles in the spec.roles field and save the file.

Using the management consoleUsing the management console

1. If you have not opened a project yet, select one.
2. In the left-hand menu, select ClickHouse® clusters.
3. Select a cluster.
4. Go to the Users tab.
5. Click the user name to open the card. The General tab displays assigned roles and status. To view the resource manifest, go to the YAML tab.
6. Click Edit.
7. Change the composition of roles in the Roles field.
8. Click Save.