Help Center/ Data Admin Service/ API Reference/ APIs (in OBT)/ Cloud DBA/ Querying a Specified Database User
Updated on 2024-08-05 GMT+08:00
View PDF
Share

Querying a Specified Database User

Function

This API is used to query information of a specified database user on DAS. It does not query database user objects on a DB instance. Currently, this function is supported only for MySQL instances.

URI

GET /v3/{project_id}/instances/{instance_id}/db-users/{db_user_id}

Table 1 Path parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Project ID.

To obtain this value, see Obtaining a Project ID.

instance_id

Yes

String

Instance ID.

db_user_id

Yes

String

Database user ID.

Request Parameters

Table 2 Request header parameters

Parameter

Mandatory

Type

Description

X-Auth-Token

Yes

String

User token.

X-Language

No

String

Language.

The value can be:

  • zh-cn
  • en-us

Response Parameters

Status code: 200

Table 3 Response body parameters

Parameter

Type

Description

db_user

DbUser object

Information of the registered database user.
Table 4 DbUser

Parameter

Type

Description

db_user_id

String

Database user ID.

db_username

String

Database username.

Status code: 400

Table 5 Response body parameters

Parameter

Type

Description

error_code

String

Error code.

Minimum length: 8

Maximum length: 36

error_msg

String

Error message.

Minimum length: 2

Maximum length: 512

Status code: 500

Table 6 Response body parameters

Parameter

Type

Description

error_code

String

Error code.

Minimum length: 8

Maximum length: 36

error_msg

String

Error message.

Minimum length: 2

Maximum length: 512

Example Requests

Querying information about a database user

GET https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/instances/da304cd5bbb944de828759bc7be3d3fein01/db-users/fe67bf85-cbd9-4819-ba74-fa0bba141690

Example Responses

Status code: 200

Success

{
  "db_user" : {
    "db_user_id" : "2e407f6b-8c09-494a-a62f-31b01439596f",
    "db_username" : "root"
  }
}

Status Code

Status Code

Description

200

Success.

400

Client error.

500

Server error.

Error Code

For details, see Error Codes.

Parent topic: Cloud DBA