Creating a Database Role

Description

This API is used to create a database role for a specified instance.

Restrictions

• This API applies only to DDS Community Edition.
• This operation is not allowed if the DB instance is in any of the following statuses: creating, changing instance class, changing port, frozen, restarting, or abnormal.

URI

• URI format

  POST https://{Endpoint}/v3/{project_id}/instances/{instance_id}/db-role

• URI example

  https://dds.ap-southeast-1.myhuaweicloud.com/v3/0549b4a43100d4f32f51c01c2fe4acdb/instances/659914406d2c4c76bce6a028ce8d8e0din02/db-role

Request Parameters

• Parameter description

  Table 2 Parameter description

  Name	Type	Mandatory	Description
  role_name	String	Yes	The name of the role to be created. The value must be 1 to 64 characters and can contain only letters (from A to Z or from a to z), digits (from 0 to 9), hyphens (-), and periods (.).
  roles	Array of objects	No	The list of roles inherited by the new role. For details, see Table 3.
  db_name	String	No	The name of the database to which the role belongs. The default value is admin. The value must be 1 to 64 characters and can contain only letters (from A to Z or from a to z), digits (from 0 to 9), and underscores (_).

  Table 3 roles field data structure description

  Name	Type	Mandatory	Description
  role_db_name	String	Yes	The name of the database to which an inherited role belongs. The value must be 1 to 64 characters and can contain only letters (from A to Z or from a to z), digits (from 0 to 9), and underscores (_).
  role_name	String	Yes	The name of an inherited role. The value must be 1 to 64 characters and can contain only letters (from A to Z or from a to z), digits (from 0 to 9), hyphens (-), and periods (.).

Example Request

{
    "role_name": "testRole",
    "roles" : [{
        "role_name":"readWrite",
        "role_db_name":"testDb" 
    }],
    "db_name":"testDb" 
}

Response Parameters

• Response example

  {}

Status Code

For more information, see Status Code.

Error Code

For more information, see Error Code.