Updated on 2025-09-04 GMT+08:00

Revoking Permissions of a Database Account

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

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

Parameter description

**Table 1** Parameters
Parameter	Mandatory	Description
project_id	Yes	Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID.
instance_id	Yes	Specifies the DB instance ID.

**Table 2** Parameters
Parameter	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
Parameter	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.

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

**Table 4** Parameters
Parameter	Type	Description
resp	String	Returns successful if the invoking is successful.

For details, see Error Codes.