依据用户ID撤销用户权限

请求参数

下表仅列出该接口特有的请求参数和部分公共参数。更多信息请见公共参数。

返回参数

下表仅列出本接口特有的返回参数。更多信息请参见返回结构。

请求示例

POST /?Action=RevokePrivilegesForUserByID&Version=2024-08-31 HTTP/1.1
Host: open.volcengineapi.com
Content-Type: application/json; charset=UTF-8
X-Date: 20240912T092459Z
X-Content-Sha256: 287e874e******d653b44d21e
Authorization: HMAC-SHA256 Credential=Adfks******wekfwe/20240912/cn-beijing/bytehouse_ce/request, SignedHeaders=host;x-content-sha256;x-date, Signature=47a7d934ff7b37c03938******cd7b8278a40a1057690c401e92246a0e41085f

{
  "UserID": "123456",
  "Grants": {
    "Privileges": [
      {
        "Name": "SELECT",
        "Columns": [
          "column1"
        ]
      }
    ],
    "Targets": [
      {
        "Database": "db1",
        "Table": "tb1"
      }
    ],
    "OnCluster": "cluster1",
    "ClusterID": 908,
    "GrantOption": true,
    "GrantTo": "user1",
    "RawSql": "grant sql"
  }
}

返回示例

{
  "ResponseMetadata": {
    "RequestId": "20240912172508081024246015C4D83D",
    "Action": "RevokePrivilegesForUserByID",
    "Version": "2024-08-31",
    "Service": "bytehouse_ce",
    "Region": "cn-beijing"
  },
  "Result": {
    "Message": "",
    "Data": {
      "message": "successfully revoke privileges from user1"
    }
  }
}

错误码

下表为您列举了该接口与业务逻辑相关的错误码。公共错误码请参见公共错误码文档。