Updated on 2025-03-07 GMT+08:00

Deleting a Database User

Function

This API is used to delete a database user on DAS. The database user is deleted from the DAS system only. The real database user object is not deleted. Currently, only MySQL instances are supported.

URI

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

Table 1 URI parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Explanation:

Project ID of a tenant in a region

To obtain this value, see Obtaining a Project ID.

Constraints:

N/A

Values:

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

Default value:

N/A

instance_id

Yes

String

Explanation:

Unique ID of an instance

Constraints:

N/A

Values:

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

Default value:

N/A

db_user_id

Yes

String

Explanation:

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 Registering a Database User.

Constraints:

N/A

Values:

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

result

String

Explanation:

Modification result. If the deletion is successful, OK is returned.

Values:

OK

Example Request

Deleting a database user

DELETE https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/instances/da304cd5bbb944de828759bc7be3d3fein01/db-users/24c0c455-1f0e-448b-acb2-6e184b4ffcfa

Example Response

Status code: 200

Successful request

{
  "result" : "OK"
}

Status Codes

Status Code

Description

200

Successful request

400

Client error

500

Server error

Error Codes

See Error Codes.