Exporting the Permissions of Database Users or Roles

Function

This API is used to export the permission list of database users or roles. After you call this API, an output stream in XLSX format is returned.

Calling Method

For details, see Calling APIs.

URI

GET /v1/{project_id}/clusters/{cluster_id}/db-manager/users/{name}/authority/export

**Table 1** Path Parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Definition Project ID. To obtain the value, see Obtaining a Project ID. Constraints N/A Range N/A Default Value N/A
cluster_id	Yes	String	Definition Cluster ID. For details about how to obtain the value, see Obtaining the Cluster ID. Constraints N/A Range N/A Default Value N/A
name	Yes	String	Definition Database user or role name. Constraints N/A Range N/A Default Value 10000

**Table 2** Query Parameters
Parameter	Mandatory	Type	Description
offset	No	Integer	Definition Page offset, which starts from 0 (page number minus 1). Constraints N/A Range Greater than or equal to 0 Default Value 0
limit	No	Integer	Definition Size of a single page. Constraints N/A Range N/A Default Value 10000

Request Parameters

None

Response Parameters

Status code: 200

None

Example Requests

GET https://{Endpoint}/v1/0536cdee2200d5912f7cc00b877980f1/clusters/a89aea88-7ea2-40bd-8ac8-8b93e169e5d6/db-manager/users/gs_role_block/authority/export

Example Responses

None

Status Codes

Status Code	Description
200	Permission list of database users or roles. The interface returns an output stream in XLSX format.
400	Request error.
401	Authentication failed.
403	You do not have required permissions.
417	Internal server error.
500	Internal server error.