如下代碼在存儲過程中執行時報錯誤：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;
查找資料后發現，在存儲過程中添加如下內容即可：Authid Current_User，修改后的存儲過程結構如下
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) 編輯 收藏