租户创建好后，需要创建相应的Schema来存放示例数据库的对象，还要分配相应的用户和访问权限。

    1. 通过obclient连接Oracle租户。具体方法请参考“”。
    1. 创建一个Schema，即用户。
    2. Query OK, 0 rows affected (0.02 sec)
    4. obclient> grant all privileges on tpcc.* to tpcc;
    5. Query OK, 0 rows affected (0.02 sec)
    7. obclient> grant create,drop,select on *.* to tpcc;
    8. Query OK, 0 rows affected (0.01 sec)
    10. obclient> show grants for tpcc;
    11. +--------------------------------------------+
    12. | Grants for TPCC@%                          |
    13. +--------------------------------------------+
    14. | GRANT USAGE ON *.* TO 'TPCC'               |
    15. | GRANT SELECT ON "SYS".* TO 'TPCC'          |
    16. | GRANT ALL PRIVILEGES ON "TPCC".* TO 'TPCC' |
    17. +--------------------------------------------+
    18. 3 rows in set (0.01 sec)
    19. obclient>
    1. 通过用户tpcc登录到tpcc模式下。
    1. 创建数据库对象
    1. Query OK, 0 rows affected (0.21 sec)
    3. <…省略…>
    5. Query OK, 0 rows affected (0.07 sec)
    7. +-----------+------------+-------------+-----------+
    8. | SYSDATE   | TABLE_NAME | PARTITIONED | TEMPORARY |
    9. +-----------+------------+-------------+-----------+
    10. | 01-APR-20 | CUST       | YES         | N         |
    11. | 01-APR-20 | DIST       | YES         | N         |
    12. | 01-APR-20 | HIST       | YES         | N         |
    13. | 01-APR-20 | ITEM       | NO          | N         |
    14. | 01-APR-20 | LOAD_HIST  | NO          | N         |
    15. | 01-APR-20 | LOAD_PROC  | NO          | N         |
    16. | 01-APR-20 | NORD       | YES         | N         |
    17. | 01-APR-20 | ORDL       | YES         | N         |
    18. | 01-APR-20 | ORDR       | YES         | N         |
    19. | 01-APR-20 | STOK       | YES         | N         |
    20. | 01-APR-20 | WARE       | YES         | N         |
    21. +-----------+------------+-------------+-----------+
    22. 11 rows in set (0.02 sec)
    1. 创建存储过程。
    2. Query OK, 0 rows affected (0.01 sec)
    3. <…省略…>
    4. Query OK, 0 rows affected (0.01 sec)
    6. Query OK, 1 row affected (0.00 sec)
    8. Query OK, 0 rows affected (0.03 sec)
    10. +------------+----------+
    11. | TABLE_NAME | ROWS_CNT |
    12. +------------+----------+
    13. | WARE       |        2 |
    14. | DIST       |       20 |
    15. | NORD       |       40 |
    16. | ORDR       |       60 |
    17. | HIST       |      240 |
    18. | ITEM       |      622 |
    19. | ORDL       |      626 |
    20. | CUST       |     1040 |
    21. | STOK       |     1244 |
    23. 9 rows in set (0.03 sec)