Changing the Database Owner

Function

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

Before calling this API, learn how to authenticate it.
Before calling this API, learn about request header parameters.

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	Definition Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID. Constraints N/A Range N/A Default Value N/A
instance_id	Yes	Definition Instance ID. Constraints N/A Range N/A Default Value N/A

Request

**Table 2** Parameters
Parameter	Mandatory	Type	Description
owner	Yes	String	Definition New username. Constraints N/A Range The username must be different from the name of the built-in user. Default Value N/A
database	Yes	String	Definition Database name. Constraints N/A Range The database name cannot be template0, template1, or postgres. Default Value N/A

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" 
}