Revokes database access permissions of an account.
Before you call this operation, make sure that the following requirements are met:
- The ApsaraDB for RDS instance is in the running state.
- The database is in the running state.
Note
- The permissions that can be revoked include SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, and TRIGGER.
- If the instance runs SQL Server 2017 EE and PostgreSQL, this operation is not supported.
Debugging
Request parameters
Parameter | Type | Required | Example | Description |
---|---|---|---|---|
Action | String | Yes | RevokeAccountPrivilege |
The operation that you want to perform. Set the value to RevokeAccountPrivilege. |
AccountName | String | Yes | test1 |
The name of the account. |
DBInstanceId | String | Yes | rm-uf6wjk5xxxxxxx |
The ID of the instance. |
DBName | String | Yes | testDB |
The name of the database. You can revoke all permissions of the account on this database. Separate multiple databases with commas (,). |
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
RequestId | String | E22099CA-A61E-4992-A0B7-CE82DC175626 |
The ID of the request. |
Examples
Sample requests
http(s)://rds.aliyuncs.com/? Action=RevokeAccountPrivilege
&DBInstanceId=rm-uf6wjk5xxxxxxx
&AccountName=test1
&DBName=testDB
&<Common request parameters>
Sample success responses
XML
format
<RevokeAccountPrivilegeResponse>
<RequestId>E22099CA-A61E-4992-A0B7-CE82DC175626</RequestId>
</RevokeAccountPrivilegeResponse>
JSON
format
{
"RequestId":"E22099CA-A61E-4992-A0B7-CE82DC175626"
}
Error codes
For a list of error codes, visit the API Error Center.