Updated on 2024-08-28 GMT+08:00

Granting a Role to a User

Function

This API is used to grant a role to a user.

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

Constraints

This operation cannot be performed when the DB instance is in the abnormal or frozen state.

Role granting in a circle is not allowed.

URI

  • URI format

    POST /v3/{project_id}/instances/{instance_id}/db-user-role

  • Parameter description
    Table 1 Parameters

    Parameter

    Mandatory

    Description

    project_id

    Yes

    Project ID of a tenant in a region.

    To obtain it, refer to Obtaining a Project ID.

    instance_id

    Yes

    Instance ID.

Request

Table 2 Parameters

Parameter

Mandatory

Type

Description

user

Yes

String

Username.

The username must be different from the name of the built-in user.

roles

Yes

Array of strings

Role name.

The role name must be different from the names of built-in user roles.

Example Request

Grant roles user3 and user4 to the user user1.

POST https://rds.ap-southeast-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in03/db-user-role 

{ 
   "user" : "user1", 
   "roles" : [ "user3", "user4" ] 
 }

Response

  • Normal response
    Table 3 Parameters

    Parameter

    Type

    Description

    resp

    String

    Returns successful if the invoking is successful.

Status Code

Error Code

For details, see Error Codes.