ModifySecurityIPList - ApsaraDB for SelectDB - Alibaba Cloud Documentation Center

Modifies the IP addresses in a whitelist of an ApsaraDB for SelectDB instance.

Try it now

Try this API in OpenAPI Explorer, no manual signing needed. Successful calls auto-generate SDK code matching your parameters. Download it with built-in credential security for local usage.

Test

RAM authorization

The table below describes the authorization required to call this API. You can define it in a Resource Access Management (RAM) policy. The table's columns are detailed below:

Action: The actions can be used in the Action element of RAM permission policy statements to grant permissions to perform the operation.
API: The API that you can call to perform the action.
Access level: The predefined level of access granted for each API. Valid values: create, list, get, update, and delete.
Resource type: The type of the resource that supports authorization to perform the action. It indicates if the action supports resource-level permission. The specified resource must be compatible with the action. Otherwise, the policy will be ineffective.
- For APIs with resource-level permissions, required resource types are marked with an asterisk (*). Specify the corresponding Alibaba Cloud Resource Name (ARN) in the Resource element of the policy.
- For APIs without resource-level permissions, it is shown as All Resources. Use an asterisk (*) in the Resource element of the policy.
Condition key: The condition keys defined by the service. The key allows for granular control, applying to either actions alone or actions associated with specific resources. In addition to service-specific condition keys, Alibaba Cloud provides a set of common condition keys applicable across all RAM-supported services.
Dependent action: The dependent actions required to run the action. To complete the action, the RAM user or the RAM role must have the permissions to perform all dependent actions.

Action

Access level

Resource type

Condition key

Dependent action

selectdb:ModifySecurityIPList

update

*All Resource

*

None

Request parameters

Parameter	Type	Required	Description	Example
RegionId	string	Yes	The region ID of the instance.	cn-hangzhou
DBInstanceId	string	Yes	The instance ID.	selectdb-cn-7213cjv****
GroupName	string	Yes	The name of the whitelist. Default value: Default.	default
SecurityIPList	string	Yes	The IP addresses in the whitelist of the instance. Separate multiple IP addresses with commas (,).	127.0.XX.XX,127.2.XX.XX
ModifyMode	string	Yes	The mode in which you want to modify the whitelist. Valid values: 0: overwrites the IP addresses in the whitelist. 1: adds IP addresses to the whitelist. 2: removes IP addresses from the whitelist.	0

Response elements

Element	Type	Description	Example
	object	The response parameters.
RequestId	string	The request ID.	195F64C2-8F11-532B-A436-FC08A221D756
GroupName	string	The name of the whitelist.	group1
SecurityIPType	string	The IP address type.	ipv4
GroupTag	string	The tag of the whitelist.	grouptag
TaskId	integer	The task ID.	479095561
SecurityIPList	string	The IP addresses in the whitelist of the instance. Multiple IP addresses are separated by commas (,).	127.0.XX.XX,127.2.XX.XX
WhitelistNetType	string	The network type of the whitelist.	mix
DBInstanceName	string	The name of the instance.	实例测试

Examples

Success response

JSON format

{
  "RequestId": "195F64C2-8F11-532B-A436-FC08A221D756",
  "GroupName": "group1",
  "SecurityIPType": "ipv4",
  "GroupTag": "grouptag",
  "TaskId": 479095561,
  "SecurityIPList": "127.0.XX.XX,127.2.XX.XX",
  "WhitelistNetType": "mix",
  "DBInstanceName": "实例测试"
}

Error codes

HTTP status code	Error code	Error message	Description
400	InvalidSecurityIPList.Duplicate	Specified security IP list is not valid: Duplicate IP address in the list.	Illegal IP whitelist list: duplicate IP addresses exist in the list.
400	InvalidSecurityIPList.Format	Specified security IP list format is not valid.	The IP whitelist is illegal.
400	InvalidSecurityIPs.Malformed	The specified parameter "SecurityIps" is not valid.	The IP whitelist is illegal.
400	DocumentConvertFailed.ExceedFileSizeLimit	The conversion has been failed, exceed file size limit.	english description1
400	Forbidden	User not authorized to operate on the specified resource, or this API does not support RAM.	english description1
400	InvalidDBName	The specified database name is not allowed.	english description1
400	CreateOrderFailed	Failed to create order.	Failed to create order.
403	SecurityIPList.Duplicate	Specified same security IP already exists.	IP whitelist already exists.
403	DBClusterNotSupported	The requested operation can not be performed while the cluster is not sale.	The requested operation cannot be performed while the cluster is not running.
403	IncorrectDBInstanceState	Current DB instance state does not support this operation.	english description1
403	InstanceEngineType.NotSupport	The instance engine and type does not support operations.	english description1
403	InvalidDBInstanceState.NotSupport	The specified instance state does't support this operation.	The instance is in a state that does not support the current operation.
403	MoneyLessThan100	The Account Monet less Than 100.	english description1
403	OperationDenied.DBNameAndAccountPrivilegeCount	The operation is not permitted due to count of database or account privilege.	english description1
403	InsufficientResourceCapacity	The resource is out of usage.	Not enough resources, please try again later.
404	DBInstanceLocked	The current instance lock mode does not support this operation.	english description1
404	IncorrectVswitchId	The specified parameter VSwitchId is not valid.	english description1
404	InvalidApi.NotFound	Specified api is not found, please check your url and method.
404	InvalidDBInstance.NotFound	The specified instance is not found.	english description1
404	InvalidDBInstanceClass.NotFound	The specified instance classic does not exist.	english description1
404	InvalidRegionId.NotFound	The provided RegionId does not exist in our records.	english description1
404	QueryPrice.Failed	The inquiry failed. Contact Alibaba Cloud customer service representatives.	english description1

See Error Codes for a complete list.

Release notes

See Release Notes for a complete list.