Help Center> Data Lake Insight> API Reference> APIs Related to SQL Jobs> Database-related APIs> Modifying a Database Owner
View PDF

Modifying a Database Owner

Function

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

Debugging

You can debug this API in API Explorer.

URI

  • URI format

    PUT /v1.0/{project_id}/databases/{database_name}/owner

  • Parameter description
    Table 1 URI parameters

    Parameter

    Mandatory

    Type

    Description

    project_id

    Yes

    String

    Project ID, which is used for resource isolation. For details about how to obtain its value, see Obtaining a Project ID.

    database_name

    Yes

    String

    Name of a database.

Request

Table 2 Request parameters

Parameter

Mandatory

Type

Description

new_owner

Yes

String

Name of the new owner. The new user must be a sub-user of the current tenant.

Response

Table 3 Response parameters

Parameter

Mandatory

Type

Description

is_success

No

Boolean

Indicates whether the request is successfully executed. Value true indicates that the request is successfully executed.

message

No

String

System prompt. If execution succeeds, the parameter setting may be left blank.

Examples

  • Example request 
    {
    "new_owner": "scuser1"
}
  • Example response (successful request) 
    {
  "is_success": true,
  "message": ""
}

Status Codes

Table 4 describes the status code.

Table 4 Status codes

Status Code

Description

200

The modification operations are successful.

400

Request error.

500

Internal service error.

Error Codes

If an error occurs when this API is invoked, the system does not return the result similar to the preceding example, but returns the error code and error information. For details, see Error Code.

Parent topic: Database-related APIs