Updated on 2025-12-09 GMT+08:00

Changing the Database Owner

Function

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

Authorization Information

Each account has all the permissions required to call all APIs, but IAM users must be assigned the required permissions.
  • If you are using role/policy-based authorization, see Permissions and Supported Actions for details on the required permissions.
  • If you are using identity policy-based authorization, the following identity policy-based permissions are required.

Action

Access Level

Resource Type (*: required)

Condition Key

Alias

Dependencies

rds:database:update

-

-

g:EnterpriseProjectId

g:ResourceTag/<tag-key>

-

-

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

Response

  • Normal response
    Table 3 Parameters

    Parameter

    Type

    Description

    resp

    String

    Definition

    Calling result.

    Range

    Returns successful if the calling is successful.

Status Code

Error Code

For details, see Error Codes.