文档首页/ 数据治理中心 DataArts Studio/ API参考/ 数据安全API/ 权限管理接口/ 查询指定用户权限清单 - ListSecurityMemberPermissionsByUserId
更新时间:2026-11-10 GMT+08:00
分享

查询指定用户权限清单 - ListSecurityMemberPermissionsByUserId

功能介绍

查询指定用户权限清单。

权限要求:dayu_admin / te_admin / 数据安全管理员可查询任意用户;普通用户仅可查询自身权限。

调用方法

请参见如何调用API。

授权信息

账号具备所有API的调用权限,如果使用账号下的IAM用户调用当前API,该IAM用户需具备调用API所需的权限。

  • 如果使用角色与策略授权,具体权限要求请参见权限和授权项。
  • 如果使用身份策略授权,当前API调用无需身份策略权限。

URI

GET /v1/{project_id}/security/member-permission/query/{user_id}

表1 路径参数

参数

是否必选

参数类型

描述

project_id

是

String

项目ID,获取方法请参见项目ID和账号ID。

user_id

是

String

IAM用户id

表2 Query参数

参数

是否必选

参数类型

描述

user_name

否

String

用户名

limit

否

Integer

每页显示的条目数量。

offset

否

Integer

偏移量,表示从此偏移量开始查询,该值大于等于0。

datasource_type

否

String

数据源类型,HIVE

database_name

否

String

数据库名称

schema_name

否

String

Schema名,正向模糊匹配

table_name

否

String

表名称

account_type

否

String

权限账号类型

  • SELF_ACCOUNT 个人账号权限

  • WORKSPACE_ACCOUNT 空间调度账号权限

expire_status

否

String

权限状态,REVOKE_FAILED,TO_BE_REVOKE,INACTIVE,PERMANENTLY_ACTIVE,ACTIVE,EXPIRE_SOON

start_expire_time

否

Long

过期时间下界时间戳,毫秒。

end_expire_time

否

Long

过期时间上界时间戳,毫秒。

order_by

否

String

排序参数,EXPIRE_TIME

order_by_asc

否

Boolean

升序/降序。true升序,false降序

请求参数

表3 请求Header参数

参数

是否必选

参数类型

描述

workspace

是

String

工作空间ID,获取方法请参见实例ID和工作空间ID。

X-Auth-Token

是

String

IAM Token,通过调用IAM服务获取用户Token接口获取(响应消息头中X-Subject-Token的值)使用Token认证时必选。

响应参数

状态码:200

表4 响应Body参数

参数

参数类型

描述

total

Long

权限总数

result

Array of AccountPermission objects

成员权限列表(包含权限集的和权限审批)

表5 AccountPermission

参数

参数类型

描述

cluster_id

String

集群id

cluster_name

String

集群名称

column_name

String

列名

database_name

String

数据库名

datasource_type

String

数据源类型,HIVE

expire_msg

String

到期信息

expire_status

String

权限状态

  • REVOKE_FAILED 回收失败

  • TO_BE_REVOKE 待回收

  • INACTIVE 已失效

  • PERMANENTLY_ACTIVE 永久有效

  • ACTIVE 生效中

  • EXPIRE_SOON 即将到期

expire_time

Long

到期时间

id

String

权限id

instance_id

String

实例id

member_id

String

成员id

member_name

String

成员名称

permission_action

String

权限类别

  • ALL 所有权限

  • SELECT 查询

  • UPDATE 修改表

  • CREATE 创建表

  • DROP 删除表

  • ALTER 修改表结构

  • INDEX 即将到期

  • LOCK 加锁

  • READ 读

  • WRITE 写

permission_action_code

Long

权限位图

project_id

String

项目ID

row_level_security

String

行级权限表达式

row_level_security_desc

String

行级权限描述

renewal_status

String

续期工单状态,可选值:

  • ORDER_WAITING_APPROVE 工单待审批

  • NO_ORDER 无工单

  • ORDER_REJECT 工单已拒绝

schema_name

String

schema名称

table_name

String

表名

workspace_id

String

工作空间id

状态码:400

表6 响应Body参数

参数

参数类型

描述

error_code

String

错误码。

error_msg

String

错误描述。

请求示例

GET /v1/0833a5737480d53b2f25c010dc1a7b88/security/member-permission/query/767923da98514885981f13604afa714f?limit=10&offset=0

响应示例

状态码:200

{
  "result" : [ {
    "cluster_id" : "123456",
    "cluster_name" : "mrs_noauth_autotest_do_not_del",
    "column_name" : "*",
    "database_name" : "dls",
    "datasource_type" : "HIVE",
    "expire_msg" : "MRS ranger connection does not exist. Please go to the management center to create a MRS ranger connection for the cluster: [mrs_noauth_autotest_do_not_del].",
    "expire_status" : "ACTIVE",
    "expire_time" : 1762099200000,
    "id" : "00279a40593d411abd2fdfdc1a4d3480",
    "instance_id" : "dd97167b873d4a79b2aad54d4370a3bc",
    "member_id" : "0833a573fe80d5401f6dc010a775569a",
    "member_name" : "ei_member",
    "permission_action" : "SELECT",
    "permission_action_code" : 2,
    "project_id" : "0833a5737480d53b2f25c010dc1a7b88",
    "renewal_status" : "ORDER_WAITING_APPROVE",
    "row_level_security" : null,
    "row_level_security_desc" : null,
    "schema_name" : "",
    "table_name" : "aa11111",
    "workspace_id" : "4f6186e2483245bf87a3b8a907ad5595"
  } ],
  "total" : 227
}

SDK代码示例

SDK代码示例如下。

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
package com.huaweicloud.sdk.test;

import com.huaweicloud.sdk.core.auth.ICredential;
import com.huaweicloud.sdk.core.auth.BasicCredentials;
import com.huaweicloud.sdk.core.exception.ConnectionException;
import com.huaweicloud.sdk.core.exception.RequestTimeoutException;
import com.huaweicloud.sdk.core.exception.ServiceResponseException;
import com.huaweicloud.sdk.dataartsstudio.v1.region.DataArtsStudioRegion;
import com.huaweicloud.sdk.dataartsstudio.v1.*;
import com.huaweicloud.sdk.dataartsstudio.v1.model.*;


public class ListSecurityMemberPermissionsByUserIdSolution {

    public static void main(String[] args) {
        // The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
        // In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
        String ak = System.getenv("CLOUD_SDK_AK");
        String sk = System.getenv("CLOUD_SDK_SK");
        String projectId = "{project_id}";

        ICredential auth = new BasicCredentials()
                .withProjectId(projectId)
                .withAk(ak)
                .withSk(sk);

        DataArtsStudioClient client = DataArtsStudioClient.newBuilder()
                .withCredential(auth)
                .withRegion(DataArtsStudioRegion.valueOf("<YOUR REGION>"))
                .build();
        ListSecurityMemberPermissionsByUserIdRequest request = new ListSecurityMemberPermissionsByUserIdRequest();
        request.withUserId("{user_id}");
        try {
            ListSecurityMemberPermissionsByUserIdResponse response = client.listSecurityMemberPermissionsByUserId(request);
            System.out.println(response.toString());
        } catch (ConnectionException e) {
            e.printStackTrace();
        } catch (RequestTimeoutException e) {
            e.printStackTrace();
        } catch (ServiceResponseException e) {
            e.printStackTrace();
            System.out.println(e.getHttpStatusCode());
            System.out.println(e.getRequestId());
            System.out.println(e.getErrorCode());
            System.out.println(e.getErrorMsg());
        }
    }
}
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
# coding: utf-8

import os
from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdkdataartsstudio.v1.region.dataartsstudio_region import DataArtsStudioRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdkdataartsstudio.v1 import *

if __name__ == "__main__":
    # The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
    # In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
    ak = os.environ["CLOUD_SDK_AK"]
    sk = os.environ["CLOUD_SDK_SK"]
    projectId = "{project_id}"

    credentials = BasicCredentials(ak, sk, projectId)

    client = DataArtsStudioClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(DataArtsStudioRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = ListSecurityMemberPermissionsByUserIdRequest()
        request.user_id = "{user_id}"
        response = client.list_security_member_permissions_by_user_id(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    dataartsstudio "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/dataartsstudio/v1"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/dataartsstudio/v1/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/dataartsstudio/v1/region"
)

func main() {
    // The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
    // In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
    ak := os.Getenv("CLOUD_SDK_AK")
    sk := os.Getenv("CLOUD_SDK_SK")
    projectId := "{project_id}"

    auth, err := basic.NewCredentialsBuilder().
        WithAk(ak).
        WithSk(sk).
        WithProjectId(projectId).
        SafeBuild()

    if err != nil {
        fmt.Println(err)
        return
    }

    hcClient, err := dataartsstudio.DataArtsStudioClientBuilder().
         WithRegion(region.ValueOf("<YOUR REGION>")).
         WithCredential(auth).
         SafeBuild()


    if err != nil {
        fmt.Println(err)
        return
    }

    client := dataartsstudio.NewDataArtsStudioClient(hcClient)

    request := &model.ListSecurityMemberPermissionsByUserIdRequest{}
	request.UserId = "{user_id}"
	response, err := client.ListSecurityMemberPermissionsByUserId(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

更多编程语言的SDK代码示例,请参见API Explorer的代码示例页签,可生成自动对应的SDK代码示例。

状态码

状态码

描述

200

ok

400

Bad Request

相关文档