[TOC] # 修改租户 ## 通过 SQL 语句修改租户 修改租户命令的语法如下： ~~~ ALTER TENANT {tenant_name | ALL} [SET] [tenant_option_list] [opt_global_sys_vars_set] tenant_option_list: tenant_option [, tenant_option ...] tenant_option: COMMENT [=]'string' |{CHARACTER SET | CHARSET} [=] charsetname |COLLATE [=] collationname |REPLICA_NUM [=] num |ZONE_LIST [=] (zone [, zone…]) |PRIMARY_ZONE [=] zone |RESOURCE_POOL_LIST [=](poolname [, poolname…]) |DEFAULT TABLEGROUP [=] {NULL | tablegroupname} |{READ ONLY | READ WRITE} |LOGONLY_REPLICA_NUM [=] num |LOCALITY [=] 'locality description' |LOCK|UNLOCK; opt_global_sys_vars_set: VARIABLES system_var_name = expr [,system_var_name = expr] ... ~~~ 锁定租户`TENANT1`的示例如下： ~~~ obclient> ALTER TENANT TENANT1 LOCK; ~~~ 更多`ALTER TENANT`语句的信息请参见[ALTER TENANT](https://open.oceanbase.com/docs/community/oceanbase-database/V3.1.0/alter-tenant)。