UpdateGrantsForRole - 更新角色权限--ByteHouse 企业版-火山引擎

文档中心

导航

UpdateGrantsForRole - 更新角色权限

最近更新时间：2024.10.09 17:05:55首次发布时间：2024.10.09 17:01:19

更新角色权限

请求参数

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

参数	类型	是否必填	示例值	描述
Action	String	是	UpdateGrantsForRole	要执行的操作，取值：UpdateGrantsForRole。
Version	String	是	2024-08-31	API的版本，取值：2024-08-31。
RoleID	Integer	是	12345	角色id
ActionType	String	是	GRANT	权限操作，取值为"GRANT"或者"REVOKE"
Grants	Array of Object	是	[ { "Privileges": [ { "Name": "SELECT", "Columns": [ "column1" ] } ], "Targets": [ { "database": "db1", "table": "tb1" } ], "OnCluster": "cluster1", "ClusterID": 721, "GrantOption": true, "GrantTo": "role1", "RawSql": "grant sql" } ]	授予的权限，数组长度需大于0，否则报错BadRequest

返回参数

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

参数	类型	示例值	描述
Message	String		top响应信息
Data	Object	{ "Message": "successfully update grants for role1" }	返回数据

请求示例

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

{
  "RoleID": 12345,
  "ActionType": "GRANT",
  "Grants": [
    {
      "Privileges": [
        {
          "Name": "SELECT",
          "Columns": [
            "column1"
          ]
        }
      ],
      "Targets": [
        {
          "Database": "db1",
          "Table": "tb1"
        }
      ],
      "OnCluster": "cluster1",
      "ClusterID": 954,
      "GrantOption": true,
      "GrantTo": "role1",
      "RawSql": "grant sql"
    }
  ]
}

返回示例

{
  "ResponseMetadata": {
    "RequestId": "20240912215341192074065120777879",
    "Action": "UpdateGrantsForRole",
    "Version": "2024-08-31",
    "Service": "bytehouse_ce",
    "Region": "cn-beijing"
  },
  "Result": {
    "Message": "",
    "Data": {
      "Message": "successfully update grants for role1"
    }
  }
}

错误码

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

状态码	错误码	错误信息	说明
400	Bad Request	api service received invalid request format	参数错误
401	SignatureNotMatch	The request signature provided is incorrect.
500	InternalError	The request has failed due to an unknown error.
503	ServiceUnavailable	The request has failed due to a temporary failure of the server.