更新用户授予的角色和权限

请求参数

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

返回参数

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

请求示例

POST /?Action=UpdateGrantsForUser&Version=2024-08-31 HTTP/1.1
Host: open.volcengineapi.com
Content-Type: application/json; charset=UTF-8
X-Date: 20240912T043933Z
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

{
  "Username": "user1",
  "ActionType": "GRANT",
  "Grants": [
    {
      "Privileges": [
        {
          "Name": "SELECT",
          "Columns": [
            "column1"
          ]
        }
      ],
      "Targets": [
        {
          "Database": "db1",
          "Table": "tb1"
        }
      ],
      "OnCluster": "cluster1",
      "ClusterID": 673,
      "GrantOption": true,
      "GrantTo": "user1",
      "RawSql": "grant sql"
    }
  ],
  "Assignments": [
    {
      "RoleID": 123456,
      "RoleName": "role1",
      "RoleIsDefault": true,
      "OnCluster": "cluster1",
      "ClusterID": 12345,
      "AdminOption": true,
      "GrantTo": "user1",
      "RawSql": "grant sql",
      "Immutable": true,
      "ImmutableReason": "QWg"
    }
  ]
}

返回示例

{
  "ResponseMetadata": {
    "RequestId": "202409121240170520760551000644EA",
    "Action": "UpdateGrantsForUser",
    "Version": "2024-08-31",
    "Service": "bytehouse_ce",
    "Region": "cn-beijing"
  },
  "Result": {
    "Message": "",
    "Data": {
      "Message": "successfully update grants for admin1"
    }
  }
}

错误码

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