Help Center/ Data Admin Service/ API Reference/ APIs (in OBT)/ Intelligent O&M/ Querying Database User Information
Updated on 2026-01-20 GMT+08:00
View PDF
Share

Querying Database User Information

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, only MySQL instances are supported.

Authorization Information

Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.

  • If you are using role/policy-based authorization, see the required permissions in Permissions Policies and Supported Actions.
  • If you are using identity policy-based authorization, the following identity policy-based permissions are required.

    Action

    Access Level

    Resource Type (*: required)

    Condition Key

    Alias

    Dependencies

    das:clouddba:getDbUser

    read

    Instance

    -

    -

    -

URI

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

Table 1 URI parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Definition

Project ID of a tenant in a region

To obtain this value, see Obtaining a Project ID.

Constraints

N/A

Range

The value can contain 32 characters. Only letters and digits are allowed.

Default Value

N/A

instance_id

Yes

String

Definition

Unique ID of an instance

Constraints

N/A

Range

The value can contain 32 characters. Only letters and digits are allowed.

Default Value

N/A

db_user_id

Yes

String

Definition

Database user ID, that is, ID of a connection established between the database account and the database. A database user ID is created by calling the API in Creating a Database User.

Constraints

N/A

Range

The value is a UUID containing 36 characters. Only letters, digits, and hyphens (-) are allowed.

Default Value

N/A

Request Parameters

None

Response Parameters

Status code: 200

Table 2 Response body parameters

Parameter

Type

Description

db_user

DbUser object

Definition

Database user information

Range

N/A
Table 3 DbUser

Parameter

Type

Description

db_user_id

String

Definition

Database user ID, that is, ID of a connection established between the database account and the database. A database user ID is created by calling the API in Creating a Database User.

Range

The value is a UUID containing 36 characters. Only letters, digits, and hyphens (-) are allowed.

db_username

String

Definition

Database username

Range

N/A

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

Successful response

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

Status Codes

Status Code

Description

200

Successful response

400

Client error

500

Server error

Error Codes

See Error Codes.

Parent topic: Intelligent O&M