Domain name for API request: cynosdb.intl.tencentcloudapi.com.
This API is used to query the permissions of an account.
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: DescribeAccountPrivileges. |
| Version | Yes | String | Common Params. The value used for this API: 2019-01-07. |
| Region | Yes | String | Common Params. For more information, please see the list of regions supported by the product. This API only supports: ap-bangkok, ap-beijing, ap-chengdu, ap-chongqing, ap-guangzhou, ap-hongkong, ap-jakarta, ap-nanjing, ap-seoul, ap-shanghai, ap-shenzhen-fsi, ap-singapore, ap-tokyo, eu-frankfurt, na-ashburn, na-siliconvalley, sa-saopaulo. |
| ClusterId | Yes | String | Cluster ID. |
| AccountName | Yes | String | Account name |
| Host | Yes | String | Host |
| Db | No | String | Database name. If it is *, Type/TableName are ignored, which means querying the user's global permission. If not passed, it defaults to *. |
| Type | No | String | Specific object types under the designated database. Options: "table", "*". Defaults to * if not specified. TableName must be specified when Type is table. |
| TableName | No | String | When Type is "table", it is used to specify the table name. Required when Type is "table". |
| Parameter Name | Type | Description |
|---|---|---|
| Privileges | Array of String | Permission list. Example value: ["","select","update","delete","create","drop","references","index","alter","show_db","create_tmp_table","lock_tables","execute","create_view","show_view","create_routine","alter_routine","event","trigger"] |
| RequestId | String | The unique request ID, generated by the server, will be returned for every request (if the request fails to reach the server for other reasons, the request will not obtain a RequestId). RequestId is required for locating a problem. |
Query permissions of an account
POST / HTTP/1.1
Host: cynosdb.intl.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: DescribeAccountPrivileges
<Common request parameters>
{
"ClusterId": "cynosdbmysql-xxxxxx",
"AccountName": "andy",
"Host": "1.1.1.1",
"Db": "Db1",
"Type": "table",
"TableName": "Table1"
}{
"Response": {
"Privileges": [
"select",
"update",
"delete",
"create",
"drop",
"references",
"index",
"alter",
"show_db",
"create_tmp_table",
"lock_tables",
"execute",
"create_view",
"show_view",
"create_routine",
"alter_routine",
"event",
"trigger"
],
"RequestId": "167350"
}
}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.DatabaseAccessError | Database access failed. Try again later. If the issue persists, contact customer service. |
| FailedOperation.OperationFailedError | Operation failed. Try again later. If the issue persists, contact customer service. |
| InternalError.DbOperationFailed | Query database failed. |
| InternalError.GetSecurityGroupDetailFailed | Failed to obtain the security group information. |
| InternalError.GetSubnetFailed | Failed to obtain the subnet. |
| InternalError.GetVpcFailed | Failed to get the VPC. |
| InternalError.ListInstanceFailed | Failed to query the instance in the security group. |
| InternalError.OperateWanFail | Operation on the public network failed. |
| InternalError.OperationNotSupport | The operation is not supported. |
| InternalError.QueryDatabaseFailed | Query database failed. |
| InternalError.SystemError | Internal system error. |
| InvalidParameter.IsolateNotAllowed | The current instance is non-isolatable. |
| InvalidParameterValue.AccountExist | The account already exists. |
| InvalidParameterValue.AccountNotExistError | The instance does not have an account. |
| InvalidParameterValue.DBTypeNotFound | Unsupported instance type. |
| InvalidParameterValue.FlowNotFound | Task flow ID does not exist. |
| InvalidParameterValue.IllegalInstanceName | Instance name contains illegal characters. |
| InvalidParameterValue.IllegalOrderBy | Invalid sorting field. |
| InvalidParameterValue.IllegalPassword | The password does not meet requirements. |
| InvalidParameterValue.InstanceNotFound | The instance does not exist. |
| InvalidParameterValue.InternalAccount | No operations allowed for built-in accounts. |
| InvalidParameterValue.InvalidDBVersion | Invalid instance version. |
| InvalidParameterValue.InvalidParameterValueError | Parameter value is invalid. |
| InvalidParameterValue.InvalidSpec | Invalid instance specification. |
| InvalidParameterValue.ParamError | Parameter error. |
| InvalidParameterValue.RegionZoneUnavailable | The selected region and availability zone are unavailable. |
| InvalidParameterValue.StoragePoolNotFound | Storage pool not found. |
| InvalidParameterValue.SubnetNotFound | Subnet not found. |
| InvalidParameterValue.VpcNotFound | The selected VPC network is not found. |
| LimitExceeded.UserInstanceLimit | Number of user instances exceeds the limit. |
| OperationDenied.InstanceStatusDeniedError | Operation not allowed in the current instance status. |
| OperationDenied.ServerlessClusterStatusDenied | Operation not allowed in the current status of the serverless cluster. |
| ResourceNotFound.ClusterNotFoundError | The cluster does not exist. |
| ResourceUnavailable.InstanceLockFail | Failed to lock the instance. It is temporarily inoperable. |
| ResourceUnavailable.InstanceStatusAbnormal | Instance status is abnormal and temporarily not operable. |
| UnauthorizedOperation.PermissionDenied | CAM authentication failed. |
피드백