Updated on 2024-07-04 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.

Constraints

Databases cannot be created when the DB instance is in any of the following statuses: creating, changing instance class, changing port, or abnormal.

URI

  • URI format

    DELETE https://{Endpoint}/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

    Specifies the database name.

    users

    Yes

    Array of objects

    Specifies the account that associated with the database. 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.

    It contains 1 to 128 characters and must be different from system usernames.

    System users include rdsadmin, rdsuser, rdsbackup, and rdsmirror.

  • Request example
    {
        "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

For details, see Status Codes.

Error Code

For details, see Error Codes.