---
title: "修改租户 | OceanBase 文档中心"
description: "修改租户 本节主要介绍如何修改租户的属性信息。 通过 SQL 语句修改租户 修改租户命令的语法如下： ALTER TENANT {tenant_name | ALL} [SET] [tenant_option_list] [opt_global_sys_vars_set] tenant_option_list: te…"
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 3.1.1 社区版

# 修改租户

更新时间：2023-08-07 17:30:32

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V3.1.1/zh-CN/600.administrator-guide/300.basic-database-management/500.tenant-management/500.modify-a-tenant.md)  

本节主要介绍如何修改租户的属性信息。

## 通过 SQL 语句修改租户

修改租户命令的语法如下：

```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` 的示例如下：

```sql
obclient> ALTER TENANT TENANT1 LOCK;

```

更多 `ALTER TENANT` 语句的信息请参见 [ALTER TENANT](https://www.oceanbase.com/docs/community-observer-cn-10000000000013846)。

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线