dbms_java.grant_Permissio 使用/ORA-29532

................[@more@]

项目中,要用到一个上传文档的功能,用一个orcale的的存储过程去调用 java 类,再由java类调用系统指指令,但始终报一个这样的错误 dbms_java.grant_Permissio('SCOTT','java.io.FilePermission','/tmp/inbound/**','read,write,execute,delete');
ORA-29532: Java call terminated by uncaught Java exception:
oracle.aurora.vm.IdNotFoundException: my_user is not a user or role,
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.SecurityException: policy table update SYS:java.io.FilePermission,
'/tmp/inbound/*

解决方法:

call dbms_java.grant_permission( 'TEST', 'SYS:java.io.FilePermission', '/tmp/inbound/*', 'read, write' );

请使用浏览器的分享功能分享到微信等