# 2021-11-04-14:20:00 +0800 Adjust tenantID of users

- Cause:

The Management portal only allows users under org with tenantID 1 to access.
https://jira.tidbcloud.com/browse/TCOC-183 and https://jira.tidbcloud.com/browse/TCOC-181

- Operation:

  - Execute the following SQL commands:

    ``` sql
    update users set tenant_id=1 where email='likun@pingcap.com';
    update tenants set status='deleted' where email='likun@pingcap.com';
    update users set tenant_id=1 where email='wangge@pingcap.com';
    update users set tenant_id=1 where email='jinlong.liu@pingcap.com';
    update users set tenant_id=1 where email='yahonda@pingcap.com';
    update tenants set status='deleted' where email='yahonda@pingcap.com';
    update tenants set status='deleted' where email='fengbiao.liang@pingcap.com';
    update users set tenant_id=1 where email='fengbiao.liang@pingcap.com';
    ```

- Impact:
The above users will be tranfered to org with tenantID 1, And delete useless orgs.

- Recovery operation:

Execute the following SQL command to revert the changes

- Time window:

2021-11-04 14:20 ~ 14:30 CST