You can call the DeleteAccount operation to delete an account from an ApsaraDB RDS instance.

Before you call this operation, make sure that the instance is in the Running state. If the instance is not in the Running state, the operation fails.

Note
  • This operation is not supported for instances that run SQL Server 2017 EE, PostgreSQL with local SSDs.
  • If you want to delete an account from an instance that runs PostgreSQL with standard SSDs or enhanced SSDs (ESSDs) and the account has permissions on specific objects such as databases and tables, this operation reports the "Some objects depend on account" error. Before you can delete the account, you must remove the permissions from the account.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String Yes DeleteAccount

The operation that you want to perform. Set the value to DeleteAccount.

AccountName String Yes test1

The name of the account.

DBInstanceId String Yes rm-uf6wjk5xxxxxxx

The ID of the instance.

Response parameters

Parameter Type Example Description
RequestId String 91E855E5-7E80-4955-929B-C74EE1D38C66

The ID of the request.

Examples

Sample requests

http(s)://rds.aliyuncs.com/?Action=DeleteAccount
&DBInstanceId=rm-uf6wjk5xxxxxxx
&AccountName=test1
&<Common request parameters>

Sample success responses

XML format

<DeleteAccountResponse>
      <RequestID>91E855E5-7E80-4955-929B-C74EE1D38C66</RequestID>
</DeleteAccountResponse>

JSON format

{
    "RequestID":"91E855E5-7E80-4955-929B-C74EE1D38C66"
}

Error codes

For a list of error codes, visit the API Error Center.