Updated on 2024-06-07 GMT+08:00

Changing the Database Owner

Function

This API is used to change the owner of a database.

  • 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.

URI

  • URI format

    POST /v3/{project_id}/instances/{instance_id}/database/owner

  • 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

owner

Yes

String

New username.

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

database

Yes

String

Database name.

The database name cannot be template0, template1, or postgres.

Example Request

Change the owner of the db1 database to username1.

POST https://rds.ap-southeast-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in03/database/owner

{ 
  "owner" : "username1", 
  "database" : "db1" 
}

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.