问题:OB库4.2.5.4版本,执行到这一句的时候,报没有权限:
[root@lnob ~]# obclient -h192.168.207.28 -P2881 -ugistar@lnzyob -pxxxxxx -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221557519
Server version: OceanBase 4.2.5.4 (r104030022025070212-37927c3517f028002a34b40302f78cce88afdbd9) (Built Jul 2 2025 12:21:09)
Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient(GISTAR@lnzyob)[GISTAR]> exec PKG_HP_HISTORYDATA.SP_CREATE_ALL_HISTORY_TABLE;
ORA-01031: insufficient privileges
at package body GISTAR.PKG_HP_HISTORYDATA.CREATE_HISTORY_TABLE , line : 64, col : 11
at package body GISTAR.PKG_HP_HISTORYDATA.SP_CREATE_ALL_HISTORY_TABLE , line : 72, col : 11
at anonymous block , line : 1, col : 6
obclient(GISTAR@lnzyob)[GISTAR]> GRANT EXECUTE ON PKG_HP_HISTORYDATA TO GISTAR;
Query OK, 0 rows affected (0.005 sec)
obclient(GISTAR@lnzyob)[GISTAR]> exec PKG_HP_HISTORYDATA.SP_CREATE_ALL_HISTORY_TABLE;
ORA-01031: insufficient privileges
at package body GISTAR.PKG_HP_HISTORYDATA.CREATE_HISTORY_TABLE , line : 64, col : 11
at package body GISTAR.PKG_HP_HISTORYDATA.SP_CREATE_ALL_HISTORY_TABLE , line : 72, col : 11
at anonymous block , line : 1, col : 6
处理办法:
obclient(GISTAR@lnzyob)[GISTAR]> GRANT CREATE ANY TABLE TO GISTAR;
Query OK, 0 rows affected (0.090 sec)
obclient(GISTAR@lnzyob)[GISTAR]> exec PKG_HP_HISTORYDATA.SP_CREATE_ALL_HISTORY_TABLE;
Query OK, 1 row affected (33.613 sec)
obclient(GISTAR@lnzyob)[GISTAR]>