This topic describes how to create and delete database accounts in an ApsaraDB for ClickHouse cluster that runs Enterprise Edition. The topic also describes how to modify the permissions and change the passwords of database accounts.
Usage notes
You can create up to 500 database accounts in an Enterprise Edition cluster.
Create a database account
Log on to the ApsaraDB for ClickHouse console.
In the top navigation bar, select the region in which the cluster that you want to manage resides.
On the Clusters page, click the Enterprise Edition Clusters tab and click the ID of the cluster that you want to manage.
In the left-side navigation pane of the page that appears, click Account Management.
In the upper-left corner of the User Account tab, click Create Account.
In the panel that appears, configure the required parameters. The following table describes the parameters.
Parameter
Description
Database Account
The name of the database account. The name must meet the following requirements:
The name must be unique.
The name can contain lowercase letters, digits, and underscores (_).
The name must start with a lowercase letter and end with a lowercase letter or digit.
The name must be 2 to 64 characters in length.
Account Type
The type of the database account. Valid values:
Privileged Account
Standard Account
Password
The password of the database account. The password must meet the following requirements:
The password must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters.
The following special characters are supported: ! @ # $ % ^ & * ( ) _ + - =.
The password must be 8 to 32 characters in length.
Confirm Password
The same password that you entered in the Password field.
Description
The description of the database account. The description must meet the following requirements:
The description can be up to 256 characters in length or an empty string.
The description cannot start with http:// or https://.
Click OK.
Modify permissions
Log on to the ApsaraDB for ClickHouse console.
In the top navigation bar, select the region in which the cluster that you want to manage resides.
On the Clusters page, click the Enterprise Edition Clusters tab and click the ID of the cluster that you want to manage.
In the left-side navigation pane of the page that appears, click Account Management.
On the User Account tab, find the database account that you want to manage and click Modify Permissions in the Actions column.
In the Modify Permissions dialog box, configure the Authorize Database Access Scope, Authorize Dictionary Access Scope, Grant DDL Permissions, and Authorize DML Permission Scope parameters based on your business requirements.
Click OK.
Change the password of a database account
Log on to the ApsaraDB for ClickHouse console.
In the top navigation bar, select the region in which the cluster that you want to manage resides.
On the Clusters page, click the Enterprise Edition Clusters tab and click the ID of the cluster that you want to manage.
In the left-side navigation pane of the page that appears, click Account Management.
On the User Account tab, find the database account whose password you want to change and click Reset Password in the Actions column.
In the Reset Password pane, enter and confirm the new password.
Click OK.
Delete a database account
Log on to the ApsaraDB for ClickHouse console.
In the top navigation bar, select the region in which the cluster that you want to manage resides.
On the Clusters page, click the Enterprise Edition Clusters tab and click the ID of the cluster that you want to manage.
In the left-side navigation pane of the page that appears, click Account Management.
On the User Account tab, find the database account that you want to delete and choose
> Delete. In the dialog box that appears, click OK.
What to do next
You can connect to a database. For more information, see Database connectivity.
References
For more information about how to create and grant permissions to Community-compatible Edition clusters, see Manage database accounts of Community-compatible Edition clusters.
For more information about how to grant permissions to a database account, see GRANT.