当前位置: 代码迷 >> Oracle开发 >> insufficient privilege解决方案
  详细解决方案

insufficient privilege解决方案

热度:65   发布时间:2016-04-24 07:21:15.0
insufficient privilege
CREATE OR REPLACE PROCEDURE RunHost Command (command IN VARCHAR2) AS LANGUAGE JAVA NAME 'obackup.backUpDataBaseOracle(java.lang.String)';
创建存储过程是出错,insufficient privilege。要给什么权限才可以?

------解决方案--------------------
SQL code
--试下grant create any procedure to 用户名;grant alter any procedure to 用户名;grant drop any procedure to 用户名;grant execute any procedure to 用户名;
------解决方案--------------------
SQL code
grant resource to tony;
  相关解决方案