Create and manage database accounts for your ApsaraDB for ClickHouse Enterprise Edition cluster. This topic covers creating accounts, modifying permissions, resetting passwords, and deleting accounts.
Each Enterprise Edition cluster supports up to 500 database accounts.
Account types
ApsaraDB for ClickHouse Enterprise Edition provides two account types:
| Account type | Description |
|---|---|
| Privileged Account | — |
| Standard Account | — |
Create a database account
Prerequisites
Before you begin, make sure you have:
An ApsaraDB for ClickHouse Enterprise Edition cluster
Access to the ApsaraDB for ClickHouse console
Procedure
Log on to the ApsaraDB for ClickHouse console.
In the upper-left corner, select the region where your cluster is located.
On the Clusters page, click the Enterprise Edition Clusters tab, then click the ID of your cluster.
In the left navigation pane, click Account Management.
On the Account Management page, click Create Account.
In the Create Account panel, configure the following parameters.
Parameter Description Database account The account name. The name must be 2–64 characters long, contain only lowercase letters, digits, or underscores ( _), start with a lowercase letter, and end with a lowercase letter or digit. The name must be unique within the cluster.Account type Select Privileged Account or Standard Account. For details, see Account types. Password The account password. Must be 8–32 characters long and contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters ( !@#$%^&*()_+-=).Confirm password Re-enter the password to confirm. Description (Optional) A description for the account. Must be 0–256 characters long and cannot start with http://orhttps://. Leave blank if not needed.Click OK.
Modify permissions
Log on to the ApsaraDB for ClickHouse console.
In the upper-left corner, select the region where your cluster is located.
On the Clusters page, click the Enterprise Edition Clusters tab, then click the ID of your cluster.
In the left navigation pane, click Account Management.
On the Account Management page, find the account and click Modify Permissions in the Actions column.
In the Modify Permissions panel, update the following settings as needed.
Setting Description Database and dictionary access scope The databases and dictionaries the account can access. DML permissions Data manipulation language permissions for the account. DDL permissions Data definition language permissions for the account. Click OK.
Reset a password
Log on to the ApsaraDB for ClickHouse console.
In the upper-left corner, select the region where your cluster is located.
On the Clusters page, click the Enterprise Edition Clusters tab, then click the ID of your cluster.
In the left navigation pane, click Account Management.
On the Account Management page, find the account and click Reset Password in the Actions column.
In the Reset Password panel, enter and confirm the new password.
Click OK.
Delete a database account
Log on to the ApsaraDB for ClickHouse console.
In the upper-left corner, select the region where your cluster is located.
On the Clusters page, click the Enterprise Edition Clusters tab, then click the ID of your cluster.
In the left navigation pane, click Account Management.
On the Account Management page, find the account. In the Actions column, click the
icon and select Delete.In the Delete Account dialog box, click OK.
Next steps
After creating accounts, connect your application to the cluster. For details, see Connect to a database.