Analysis clusters cannot synchronize the account information from the source instance, and account creation cannot be performed via the command line for analysis clusters. You can create accounts for analysis clusters through the console. This document describes how to create accounts and grant permissions on the console.
Operation Steps
2. In the cluster list, click the target analysis clusters to go to the cluster management page, then click Account Management > Create Account.
3. Complete the settings in the pop-up window, then click OK.
Account Name: The account name must be 1 - 30 characters long, consisting of letters, numbers, and special characters; it must start with a letter and end with a letter or number. The special character is underscore (_).
Host: Entering IP addresses is supported. To configure all hosts, enter %.
Set Password: 8 - 64 characters, containing any three types of uppercase letters, lowercase letters, digits, and special characters (~!@#$%^&*_-+=`|\\(){}[]:;'<>,.?/).
Permission settings
Note:
The root account does not support modifying permissions.
1. Under the account management page, locate the target account and click Modify Permissions in the Operation column.
2. In the pop-up window, select the permissions to be granted, then click OK.
Note:
Currently, analysis clusters support setting global permissions but do not currently support object-level permissions. The supported permissions are as follows:
PROCESS
SHOW VIEW
CREATE VIEW
SELECT
SHOW DATABASES
CONNECTION ADMIN