oceanbase执行execute immediate create table提示无权限

发布于:2025-08-09 ⋅ 阅读:(13) ⋅ 点赞:(0)

问题: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]> 
 


网站公告

今日签到

点亮在社区的每一天
去签到