Configuring Account Permissions

Function

This API is used to set account permissions to read-only or read/write.

• Before calling an API, you need to understand the API in Authentication.

Constraints

This operation cannot be performed when the DB instance is in any of the following statuses: creating, changing instance class, changing port, frozen, or abnormal.

URI

• URI format

  POST /v3/{project_id}/instances/{instance_id}/user-privilege

• Parameter description

  Table 1 Parameters

  Parameter	Mandatory	Description
  project_id	Yes	Project ID of a tenant in a region. For details about how to obtain the project ID, see Obtaining a Project ID.
  instance_id	Yes	Instance ID.

Request

Example Request

• Set all database accounts to read-only.

  POST https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/f569f1358436479dbcba8603c32cc4aein03/user-privilege
  
  {
      "all_users": true,
      "readonly": true
  }

• Set all database accounts to readable and writable.

  {
      "all_users": true,
      "readonly": false
  }

• Set a single database account to read-only.

  {
      "all_users": false,
      "user_name": "test1234",
      "readonly": true
  }

• Set a single database account to readable and writable.

  {
      "all_users": false,
      "user_name": "test1234",
      "readonly": false
  }

Response

• Normal response

  None

• Example normal response

  None

• Abnormal response

  For details, see Abnormal Request Results.

Status Code

• Normal

  200

• Abnormal

  For details, see Status Codes.

Error Code

For details, see Error Codes.