Domain name for API request: sqlserver.tencentcloudapi.com.
This API is used to modify instance account permissions.
A maximum of 20 requests can be initiated per second for this API.
The following request parameter list only provides API request parameters and some common parameters. For the complete common parameter list, see Common Request Parameters.
Parameter Name | Required | Type | Description |
---|---|---|---|
Action | Yes | String | Common Params. The value used for this API: ModifyAccountPrivilege. |
Version | Yes | String | Common Params. The value used for this API: 2018-03-28. |
Region | Yes | String | Common Params. For more information, please see the list of regions supported by the product. |
InstanceId | Yes | String | Database instance ID in the format of mssql-njj2mtpl |
Accounts.N | Yes | Array of AccountPrivilegeModifyInfo | Account permission change information |
Parameter Name | Type | Description |
---|---|---|
FlowId | Integer | Async task flow ID |
RequestId | String | The unique request ID, which is returned for each request. RequestId is required for locating a problem. |
POST / HTTP/1.1
Host: sqlserver.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: ModifyAccountPrivilege
<Common request parameters>
{
"InstanceId": "mssql-njj2mtpl",
"Accounts": [
{
"UserName": "testuser",
"DBPrivileges": [
{
"Privilege": "ReadOnly",
"DBName": "testdb"
}
]
}
]
}
{
"Response": {
"RequestId": "8a61e500-aa33-454c-9ec2-da2a368c39ab",
"FlowId": "30321"
}
}
TencentCloud API 3.0 integrates SDKs that support various programming languages to make it easier for you to call APIs.
The following only lists the error codes related to the API business logic. For other error codes, see Common Error Codes.
Error Code | Description |
---|---|
FailedOperation.DBError | Database error. |
FailedOperation.GcsError | The operation failed or the network timed out. |
InternalError.SystemError | System error. |
InternalError.UnknownError | Unknown error. |
InvalidParameter.InputIllegal | Input error. |
InvalidParameter.ParamsAssertFailed | An error occurred while converting parameter assertion. |
InvalidParameterValue.AdminAccountNotUnique | You can only apply for one admin account. |
InvalidParameterValue.GrantIsIllegal | Invalid parameter. The value of GRANT is invalid. |
ResourceNotFound.AccountNotExist | The account does not exist. |
ResourceNotFound.DBNotExit | The database does not exist. |
ResourceNotFound.DBNotFound | The database does not exist. |
ResourceNotFound.InstanceNotFound | The instance does not exist. |
ResourceUnavailable.AccountInvalidStatus | Invalid account status. |
ResourceUnavailable.InstanceStatusInvalid | Invalid instance status. |
UnauthorizedOperation.PermissionDenied | CAM authentication error. |
Was this page helpful?