# 查询指定用户权限清单 - ListSecurityMemberPermissionsByUserId
#### 功能介绍
查询指定用户权限清单。
权限要求：dayu_admin / te_admin / 数据安全管理员可查询任意用户；普通用户仅可查询自身权限。
#### 调用方法
请参见[如何调用API](https://support.huaweicloud.com/api-dataartsstudio/making_request.html)。
#### 授权信息
账号具备所有API的调用权限，如果使用账号下的IAM用户调用当前API，该IAM用户需具备调用API所需的权限。
- 如果使用角色与策略授权，具体权限要求请参见[权限和授权项](https://support.huaweicloud.com/api-dataartsstudio/abcd.html)。
- 如果使用身份策略授权，当前API调用无需身份策略权限。
 
#### URI
GET /v1/{project_id}/security/member-permission/query/{user_id}
表1路径参数 
| 参数         | 是否必选 | 参数类型   | 描述                                                                                                    |
|:---|:---|:---|:---|
| project_id | 是    | String | 项目ID，获取方法请参见[项目ID和账号ID](https://support.huaweicloud.com/api-dataartsstudio/projectid_accountid.html)。 |
| user_id    | 是    | String | IAM用户id                                                                                               |
   
表2Query参数 
| 参数                | 是否必选 | 参数类型    | 描述                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
|:---|:---|:---|:---|
| 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](https://support.huaweicloud.com/api-dataartsstudio/dataartsstudio_02_0350.html)。 |
| X-Auth-Token | 是    | String | IAM Token，通过调用IAM服务获取用户Token接口获取（响应消息头中X-Subject-Token的值）使用Token认证时必选。                                       |
   
#### 响应参数
**状态码：200**
表4响应Body参数 
| 参数     | 参数类型                                                                                                     | 描述                  |
|:---|:---|:---|
| total  | Long                                                                                                     | 权限总数                |
| result | Array of [AccountPermission] objects | 成员权限列表（包含权限集的和权限审批） |
   
 表5AccountPermission 
| 参数                      | 参数类型   | 描述                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
|:---|:---|:---|
| 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代码示例如下。
- [Java]
  ```
  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());
          }
      }
  }
  ```
  
- [Python]
  ```
  # 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)
  ```
  
- [Go]
  ```
  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](https://console.huaweicloud.com/apiexplorer/#/openapi/DataArtsStudio/sdk?api=ListSecurityMemberPermissionsByUserId)的代码示例页签，可生成自动对应的SDK代码示例。
  
#### 状态码
| 状态码 | 描述          |
|:---|:---|
| 200 | ok          |
| 400 | Bad Request |
   
