You need to enable JavaScript to run this app.
导航
GrantPrivilegesToUserByID - 依据用户ID授予用户权限
最近更新时间:2024.10.09 17:05:55首次发布时间:2024.10.09 17:01:20

依据用户ID授予用户权限

请求参数

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

参数
类型
是否必填
示例值
描述
Action
String

GrantPrivilegesToUserByID

要执行的操作,取值:GrantPrivilegesToUserByID。

Version
String

2024-08-31

API的版本,取值:2024-08-31。

UserID
Integer

123456

用户ID

Grants
Array of Object

[
{
"Privileges": [
{
"Name": "SELECT",
"Nolumns": [
"column1"
]
}
],
"Targets": [
{
"Database": "db1",
"Table": "tb1"
}
],
"OnCluster": "cluster1",
"ClusterID": 137,
"GrantOption": true,
"GrantTo": "user1",
"RawSql": "grant sql"
}
]

权限信息

返回参数

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

参数
类型
示例值
描述
Message
String

top响应信息

Data
Object

{ "Message": "successfully grant privileges to user1" }

返回数据

请求示例

POST /?Action=GrantPrivilegesToUserByID&Version=2024-08-31 HTTP/1.1
Host: open.volcengineapi.com
Content-Type: application/json; charset=UTF-8
X-Date: 20240927T130640Z
X-Content-Sha256: 287e874e******d653b44d21e
Authorization: HMAC-SHA256 Credential=Adfks******wekfwe/20240927/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": 140,
      "GrantOption": true,
      "GrantTo": "user1",
      "RawSql": "grant sql"
    }
  ]
}

返回示例

{
  "ResponseMetadata": {
    "RequestId": "20240912173949051130014015BD51E7",
    "Action": "GrantPrivilegesToUserByID",
    "Version": "2024-08-31",
    "Service": "bytehouse_ce",
    "Region": "cn-beijing"
  },
  "Result": {
    "Message": "",
    "Data": {
      "Message": "successfully grant privileges to user1"
    }
  }
}

错误码

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

状态码
错误码
错误信息
说明
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.