如下代碼在存儲過程中執(zhí)行時報錯誤：ORA-01031: insufficient privileges
create or replace procedure DBA_REBUILD_INDEX
As
Begin
execute immediate 'alter index PK_DUBAI_STORAGE_OUT_MANIFEST rebuild online';
execute immediate 'alter index WATERGAUGE_PK rebuild online';
Return;
end DBA_REBUILD_INDEX;
查找資料后發(fā)現(xiàn)，在存儲過程中添加如下內(nèi)容即可：Authid Current_User，修改后的存儲過程結(jié)構(gòu)如下
create or replace procedure DBA_REBUILD_INDEX Authid Current_User
As
Begin
execute immediate 'alter index PK_DUBAI_STORAGE_OUT_MANIFEST rebuild online';
execute immediate 'alter index WATERGAUGE_PK rebuild online';
Return;
end DBA_REBUILD_INDEX;
posted on 2015-12-10 09:12
Glorin 閱讀(720)
評論(0) 編輯 收藏