Revokes permissions on a table from a user.
Debugging
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.
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.