All Products
Search
Document Center

ApsaraDB for ClickHouse:CreateSQLAccount

Last Updated:Jul 17, 2024

Creates a privileged account or a standard account for an ApsaraDB for ClickHouse cluster.

Operation description

Note This operation is applicable only to ApsaraDB for ClickHouse clusters of V20.8 or later that were created after December 1, 2021,

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer.

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

ParameterTypeRequiredDescriptionExample
DBClusterIdstringYes

The cluster ID.

cc-bp1p816075e21****
AccountNamestringYes

The name of the database account.

  • The name must be unique in the cluster.
  • The name can contain lowercase letters, digits, or underscores (_).
  • The name must start with a lowercase letter and end with a lowercase letter or a digit.
  • The name must be 2 to 64 characters in length.
test
AccountPasswordstringYes

The password of the database account.

  • The password must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters.
  • Special characters include ! @ # $ % ^ & * ( ) _ + - =
  • The password must be 8 to 32 characters in length.
Test1234
AccountDescriptionstringNo

The description of the database account.

  • The description cannot start with http:// or https://.
  • The description can be up to 256 characters in length or be an empty string.
AccountTypestringYes

The type of the database account. Valid values:

  • Super: privileged account.
  • Normal: standard account.
Super

Response parameters

ParameterTypeDescriptionExample
object

Schema of Response

RequestIdstring

The request ID.

F5178C10-1407-4987-9133-DE4DC9119F76

Examples

Sample success responses

JSONformat

{
  "RequestId": "F5178C10-1407-4987-9133-DE4DC9119F76"
}

Error codes

HTTP status codeError codeError messageDescription
404InvalidDBCluster.NotFoundThe DBClusterId provided does not exist in our records.The DBClusterId provided does not exist in our records.

For a list of error codes, visit the Service error codes.

Change history

Change timeSummary of changesOperation
No change history