Note
This variable was introduced in V2.1.
Description
The ob_tcp_invited_nodes variable specifies the IP whitelist for a tenant. It supports wildcard characters (% and _), IP addresses (separated by commas), subnet masks, and fuzzy matching.
Privilege requirements
Query variables
In the
systenant and all user tenants, you can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of a global system variable.Modify variables
In the
systenant, you can directly modify the value of a global system variable.For a MySQL user tenant, you must have the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.For an Oracle user tenant, you must have the
ALTER SYSTEMprivilege to modify the value of a global system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | 127.0.0.1,::1 |
| Value range | The length of the string is less than 65536.
NoteStarting from V4.2.1 BP1, the value range is changed from "the length of the string is less than 4096" to "the length of the string is less than 65536". |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Example
Set the IP address whitelist of the tenant to 127.0.0.1.
obclient> SET GLOBAL ob_tcp_invited_nodes='127.0.0.1';