Revokes permissions on a table from a specified user.
Try it now
Test
RAM authorization
Request syntax
PUT /api/v1/instances/{instanceId}/revokeTablePermission HTTP/1.1Path Parameters
|
Parameter |
Type |
Required |
Description |
Example |
| instanceId |
string |
No |
The instance ID. |
hgprecn-cn-i7m2v08uu00a |
Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
| body |
object |
No |
The request body. |
|
| databaseName |
string |
No |
The database name. |
test_db |
| userName |
string |
No |
The user ID. For more information, see Hologres account overview. |
p4_1234xxxx |
| schemaName |
string |
No |
The schema name. |
my_schema |
| tableName |
string |
No |
The table name. |
my_table |
| privileges |
array |
No |
The permissions to revoke. |
|
|
string |
No |
The permission to revoke. For more information, see Hologres permission model. |
INSERT |
|
| allTable |
boolean |
No |
Specifies whether this operation applies to all tables in the schema. If true, permissions are revoked from all tables. If false or not specified, permissions are revoked only from the table specified by tableName. |
false |
| columnNames |
array |
No |
The columns from which you want to revoke permissions. This is required only for column-level permissions. |
|
|
string |
No |
The column name. |
Response elements
|
Element |
Type |
Description |
Example |
|
object |
The response object. |
||
| requestId |
string |
The request ID. |
819A7F0F-2951-540F-BD94-6A41ECF0281F |
| data |
boolean |
Indicates whether the operation succeeded. A value of true indicates success and false indicates failure. |
true |
Examples
Success response
JSON format
{
"requestId": "819A7F0F-2951-540F-BD94-6A41ECF0281F",
"data": true
}Error codes
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.