Database User Management
We can create the ClickHouse database cluster users from the portal directly. We have a new section called Cluster Users and under this, we can create, edit and delete the database users. The users are common across the individual nodes of a cluster and any action performed here will be reflected in all the cluster nodes.
Select the Create User button in the Cluster Users section and fill out the details of the new user. The following details needs to be provided.
- User Name
- Password Type
- Host IP (Optional, and can be used to restrict the IP from which the use can connect to the server)
- Default Role (Administrator or Read-only)
To modify the users created via the portal, you can select the edit icon under the Actions for that particular user.
To Remove/Delete the users created via the portal, you can select the Delete icon under the Actions (next to edit icon) for that particular user.
- Every portal user will have a corresponding ClickHouse database cluster user with same login credentials as the portal
- Users/Roles directly created via ClickHouse RBAC SQL statements can not be modified in the portal