Updated on 2024-03-28 GMT+08:00

Revoking Permissions of a Database Account

Function

This API is used to revoke permissions of a database account in a specified DB instance.

  • Before calling an API, you need to understand the API in Authentication.

Constraints

  • This operation cannot be performed when the DB instance is in any of the following statuses: creating, changing instance class, changing port, or abnormal.

URI

  • URI format

    DELETE /v3/{project_id}/instances/{instance_id}/db_privilege

  • Parameter description
    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Specifies the project ID of a tenant in a region.

    For details about how to obtain the project ID, see Obtaining a Project ID.

    instance_id

    Yes

    Specifies the DB instance ID.

Request

Parameter description
Table 2 Parameter description

Name

Mandatory

Type

Description

db_name

Yes

String

Database name.

users

Yes

Array of objects

Database accounts. Each element is a database account. A single request supports a maximum of 50 elements.

For more information about the element structure, see Table 3.

Table 3 users field data structure description

Name

Mandatory

Type

Description

name

Yes

String

Specifies the username of the database account.

The username consists of 1 to 32 characters. Only lowercase letters, digits, hyphens (-), and underscores (_) are allowed.
  • If the database version is RDS for MySQL 5.6, the username consists of 1 to 16 characters.
  • If the database version is RDS for MySQL 5.7 or 8.0, the username consists of 1 to 32 characters.

Example Request

{
    "db_name": "rds-test",
    "users": [
        {
            "name": "rds"
        },
        {
            "name": "rds001"
        }
    ]
}

Response

  • Normal response
    Table 4 Parameter description

    Name

    Type

    Description

    resp

    String

    Returns successful if the invoking is successful.

Status Code

Error Code

For details, see Error Codes.