addCloudPostgresqlUserList
- Print
- PDF
addCloudPostgresqlUserList
- Print
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Available in VPC
Add DB user to Cloud DB for PostgreSQL.
Requests
Request Parameters
| Parameter | Type | Requirement Status | Description | Restrictions |
|---|---|---|---|---|
| regionCode | String | N | Region code - regionCode can be obtained via the getRegionList action - default: Selects the first region of the getRegionList query results | - |
| cloudPostgresqlInstanceNo | String | Y | Cloud DB for PostgreSQL instance number - You can obtain cloudPostgresqlServerInstanceNo through the getCloudPostgresqlInstanceList action | - |
| cloudPostgresqlUserList.N.name | List<String> | Y | Cloud DB for PostgreSQL DB User ID - Up to 10 user tasks can be performed at a time | - Only English lowercase letters, numbers, and underscore characters ( _ ) are allowed, and must start with an English letter - Not permitted to use predefined roles and reserved words - Min: 4 - Max: 16 |
| cloudPostgresqlUserList.N.clientCidr | List<String> | Y | Client CIDR of Cloud DB for PostgreSQL DB User <example> - Allow full access: 0.0.0.0/0 - Allow access to specific IPs: 192.168.1.1/32 - Allow access to an IP range: 192.168.1.0/24 | - |
| cloudPostgresqlUserList.N.password | List<String> | Y | Cloud DB for PostgreSQL DB User password | - Must contain at least 1 each of English letter, number, and special character - The following characters cannot be used in the password: ` & + \ " ' / and space - Cannot include user ID - Min: 8 - Max: 20 |
| cloudPostgresqlUserList.N.isReplicationRole | List<Boolean> | Y | Replication role status | - |
| responseFormatType | String | N | Format type of the response result - options: xml | json - default: xml | - |
Examples
Request Examples
The following is an example of a request body.
GET {API_URL}/addCloudPostgresqlUserList
?regionCode=KR
&cloudPostgresqlInstanceNo=****890
&cloudPostgresqlUserList.1.name=testuser
&cloudPostgresqlUserList.1.clientCidr=0.0.0.0/0
&cloudPostgresqlUserList.1.password=********
&cloudPostgresqlUserList.1.isReplicationRole=false
Response examples
The following are examples of responses.
If the response shows that format type (responseFormatType) is json
{
"addCloudPostgresqlUserListResponse": {
"requestId": "d35c01cf-e77a-44a9-a2b9-1fd1f9572750",
"returnCode": 0,
"returnMessage": "success"
}
}
If the response shows that format type (responseFormatType) is xml
<addCloudPostgresqlUserListResponse>
<requestId>d35c01cf-e77a-44a9-a2b9-1fd1f9572750</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
</addCloudPostgresqlUserListResponse>
Was this article helpful?