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 sys tenant and all user tenants, you can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) or the information_schema.GLOBAL_VARIABLES view (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 V4.x, starting from V4.2.0, 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
obclient> SET GLOBAL ob_tcp_invited_nodes='127.0.0.1';