Change global privileges of a role

2023-08-22 02:46:05  Updated

Description

You can call this operation to change global privileges of a role.

Call description

Prerequisites

You have passed the authentication for the OCP application service.

You have the Update permission on the specified tenant.

Request path

POST /api/v2/ob/clusters/{id}/tenants/{tenantId}/roles/{roleName}/modifyGlobalPrivilege

Request parameters

path parameters

Parameter Type Required Example value Description
id Integer Yes 1 The ID of the cluster.
tenantId Integer Yes 5 The ID of the tenant.
roleName String Yes ROLE1 The role name.

Request body parameters

Parameter Type Required Example value Description
globalPrivileges ArrayString Yes [CREATE_SESSION, CREATE_TABLE] The list of privileges to be changed to. * For MySQL tenants, it is a list of global privileges. * For Oracle tenants, it is a list of system privileges.

Response parameters

Parameter Type Description
successful Boolean Indicates whether the request was successful.
timestamp Datetime The timestamp when the server completed the request.
duration Integer The time taken by the server to process the request, in milliseconds.
status Integer An HTTP status code.
traceId String The trace ID of the request. This trace ID is used for troubleshooting.
server String The address of the application server that responded to the request.

Examples

Sample request

Change the global privileges of ROLE1 to [CREATE_SESSION, CREATE_TABLE] in Tenant 1000001 of Cluster 1.

POST /api/v2/ob/clusters/1/tenants/2000001/roles/ROLE1/modifyGlobalPrivilege?id=1&tenantId=2000001&username=USER1

{
  "globalPrivileges": [
    "CREATE_SESSION",
    "CREATE_TABLE"
  ]
}

Sample response

{
  "duration": 201,
  "server": "xx.xx.xx.xx",
  "status": 200,
  "successful": true,
  "timestamp": "2021-09-07T15:30:41.205+08:00",
  "traceId": "f4783564b21746db"
}

Contact Us