Call RevokeUserPermission to revoke user permissions.

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 Required RevokeUserPermission

The parameter specified by the system. Value: RevokeUserPermission.
DbId String Required 142345

The ID of the database.
DsType String Required DATABASE

The type of the resource. For more information about valid values and descriptions, see GrantUserPermission API.

PermTypes String Required QUERY

The type of the permission. For more information about values and descriptions, see GrantUserPermission API.

Tid Long Yes -1

The ID of the tenant.
UserAccessId String Required 123

The permission information ID of the user.
UserId String Required 1234

The user ID, which corresponds to the user ID in the GetUser API.

Note Note that it is not the Alibaba Cloud Uid of the user.
Logic Boolean No false

Indicates whether the database is a logical database. Valid values:

  • true
  • false
TableId String No 1342345

The ID of the table. This parameter is required when you grant the permission to a table.

TableName String No table_name

Table name. This parameter is required when you authorize the permissions of a table.

Response parameters

Parameter Type Example Description
ErrorCode String UnknownError

The error code.
ErrorMessage String UnknownError

The error message.
RequestId String A99CD576-1E18-4E86-931E-C3CCE56DC030

The ID of the request.
Success Boolean true

Indicates whether the request is successful. Valid values:

  • true
  • false

Examples

Sample requests

http(s)://[Endpoint]/? Action=RevokeUserPermission
&<Common request parameters>

Sample success responses

XML format 

<RequestId>A99CD576-1E18-4E86-931E-C3CCE56DC030</RequestId>
<Success>true</Success>

JSON format 

{
  "RequestId": "A99CD576-1E18-4E86-931E-C3CCE56DC030",
  "Success": true
}

Error codes

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