ApsaraDB for ClickHouse:Manage database accounts for Enterprise Edition

Notes

You can create a maximum of 500 database accounts for each Enterprise Edition cluster.

Create a database account

1. Log on to the ApsaraDB for ClickHouse console.

2. In the upper-left corner of the page, select the region where the cluster is located.

3. On the Clusters page, select the Enterprise Edition Clusters tab and click the ID of the target cluster.

4. In the left-side navigation pane, click Account Management.

5. On the Account Management page, click Create Account in the upper-left corner.

6. In the Create Account panel, configure the following parameters.

   Parameter	Description
   Database account	The name of the database account. It must meet the following requirements: Must be unique within the cluster. Can contain only lowercase letters, digits, and underscores (_). Must start with a lowercase letter and end with a lowercase letter or a digit. Must be 2 to 64 characters long.
   Account type	The type of the database account. Valid values: Privileged Account Standard Account
   Password	The password for the database account. It must meet the following requirements: Must contain characters from at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. The supported special characters are: !@#$%^&*()_+-= Must be 8 to 32 characters long.
   Confirm password	Enter the password again.
   Description	An optional description for the database account. It must meet the following requirements: Can be 0 to 256 characters long. Cannot start with http:// or https://.

7. Click OK.

Modify permissions

1. Log on to the ApsaraDB for ClickHouse console.

2. In the upper-left corner of the page, select the region where the cluster is located.

3. On the Clusters page, select the Enterprise Edition Clusters tab and click the ID of the target cluster.

4. In the left-side navigation pane, click Account Management.

5. On the Account Management page, find the target database account and click Modify Permissions in the Actions column.

6. In the Modify Permissions panel, configure the Database and Dictionary Access Scope, DML permissions, and DDL permissions.

7. Click OK.

Reset password

1. Log on to the ApsaraDB for ClickHouse console.

2. In the upper-left corner of the page, select the region where the cluster is located.

3. On the Clusters page, select the Enterprise Edition Clusters tab and click the ID of the target cluster.

4. In the left-side navigation pane, click Account Management.

5. On the Account Management page, find the target database account and click Reset Password in the Actions column.

6. In the Reset Password panel, enter and confirm the new password.

7. Click OK.

Delete a database account

1. Log on to the ApsaraDB for ClickHouse console.

2. In the upper-left corner of the page, select the region where the cluster is located.

3. On the Clusters page, select the Enterprise Edition Clusters tab and click the ID of the target cluster.

4. In the left-side navigation pane, click Account Management.

5. On the Account Management page, find the target database account, click the icon in the Actions column, and then click Delete.

6. In the Delete Account dialog box, click OK.

Next steps

To connect to an instance, see Database connectivity.

Related documents

To create accounts and grant permissions for a Community-compatible Edition cluster, see Manage database accounts for a Community-compatible Edition cluster.

To grant permissions to a database account by using SQL statements, see GRANT.