Revokes permissions on a table from a user.

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 RevokeTablePermission

The operation that you want to perform.

Actions String Yes Select,Describe

The permissions that you want to revoke. Separate multiple permissions with commas (,).

You can revoke only the SELECT, DESCRIBE, and DOWNLOAD permissions on MaxCompute tables.

MaxComputeProjectName String Yes aMaxcomputeProjectName

The name of the MaxCompute project to which the table belongs. You can log on to the DataWorks console and go to the Workspace Management page to obtain the MaxCompute project name.

RegionId String Yes cn-shanghai

The ID of the region where the MaxCompute project that contains the table resides. For example, the ID of the China (Shanghai) region is cn-shanghai, and that of the China (Zhangjiakou) region is cn-zhangjiakou. The system automatically determines the value of this parameter based on the endpoint used to call the operation.

TableName String Yes aTableName

The name of the MaxCompute table. You can call the SearchMetaTables operation to query the table name.

WorkspaceId Long Yes 12345

The ID of the DataWorks workspace with which the MaxCompute project is associated. You can log on to the DataWorks console and go to the Workspace Management page to obtain the ID.

RevokeUserName String No RAM$dataworks_3h1_1:stsramuser

The Alibaba Cloud account from which you want to revoke permissions. Specify this parameter in the format that is the same as the format of the account used to access the MaxCompute project.

  • If you want to revoke permissions from an Alibaba Cloud account, specify this parameter in the ALIYUN$+Alibaba Cloud account format.
  • If you want to revoke permissions from a Resource Access Management (RAM) user, specify this parameter in the RAM$+RAM user format.

You must specify either this parameter or RevokeUserId. If you specify both this parameter and RevokeUserId, the value of RevokeUserId prevails.

RevokeUserId String No 267842600408993176

The ID of the Alibaba Cloud account from which you want to revoke permissions. You can log on to the DataWorks console and go to the Security Settings page to obtain the ID.

You must specify either this parameter or RevokeUserName. If you specify both this parameter and RevokeUserName, the value of this parameter prevails.

Response parameters

Parameter Type Example Description
RequestId String 0bc1ec92159376****

The ID of the request.

RevokeSuccess Boolean true

Indicates whether the permissions on the table are revoked.

Examples

Sample requests

http(s)://[Endpoint]/?Action=RevokeTablePermission
&Actions=Select,Describe
&MaxComputeProjectName=aMaxcomputeProjectName
&RegionId=cn-shanghai
&TableName=aTableName
&WorkspaceId=12345
&<Common request parameters>

Sample success responses

XML format

<RevokeSuccess>true</RevokeSuccess>
<RequestId>0bc1ec92159376****</RequestId>

JSON format

{
    "RevokeSuccess": true,
    "RequestId": "0bc1ec92159376****"
}

Error codes

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