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;