read_only

Description

read_only specifies whether a tenant is in read-only mode.

Privilege requirements

• Query variables

  sys tenants and all user tenants 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 values of Global system variables.

• Modify variables

  • sys tenants can directly modify the values of Global system variables.

  • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the values of Global system variables.

  • Oracle user tenants must have the ALTER SYSTEM privilege to modify the values of Global system variables.

Attributes

Usage

After you set this variable, the setting takes effect on all ordinary users of the tenant, but not on users with the root privilege.

Examples

Set the tenant to read-write mode.

obclient> SET GLOBAL read_only = OFF;