ApsaraDB for ClickHouse:Manage Enterprise Edition accounts

Usage 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 your cluster is located.

3. On the Clusters page, click the Enterprise Edition Clusters tab, and then click the ID of the destination cluster.

4. In the navigation pane on the left, click Account Management.

5. In the upper-left corner of the Account Management page, click Create Account.

6. In the Create Account panel, set the parameters.

   Parameter	Description
   Database Account	The name of the database account. The name must meet the following requirements: The name must be unique. It must consist of lowercase letters, digits, or underscores (_). It must start with a lowercase letter and end with a lowercase letter or a digit. It 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 for the database account. The password must meet the following requirements: It must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. The following characters are special characters: !@#$%^&*()_+-= It must be 8 to 32 characters in length.
   Confirm Password	Enter the password again.
   Description	The description of the database account. The description must meet the following requirements: It can be 0 to 256 characters in length. It 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 your cluster is located.

3. On the Clusters page, click the Enterprise Edition Clusters tab, and then click the ID of the destination cluster.

4. In the navigation pane on the left, 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, modify the Database and Dictionary Access Scope, DML Permissions, and DDL Permissions for the database account as needed.

7. Click OK.

Reset a password

1. Log on to the ApsaraDB for ClickHouse console.

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

3. On the Clusters page, click the Enterprise Edition Clusters tab, and then click the ID of the destination cluster.

4. In the navigation pane on the left, 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 your cluster is located.

3. On the Clusters page, click the Enterprise Edition Clusters tab, and then click the ID of the destination cluster.

4. In the navigation pane on the left, click Account Management.

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

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

What to do next

To connect to an instance, see Connect to a database.

References

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

To grant permissions to a database account using an SQL statement, see GRANT.