jump to navigation

File permissions for Java Procedure in Oracle October 6, 2006

Posted by maxmil in : Java,Oracle , trackback

In order to read, write, delete, execute files from an Oracle proceedure written in Java a dba user must issue the following grants:

EXEC DBMS_JAVA.grant_permission(‘SCHEMA-NAME’, ‘java.io.FilePermission’, ‘<<ALL FILES>>’, ‘read ,write, execute, delete’);
EXEC DBMS_JAVA.grant_permission(‘SCHEMA-NAME’, ‘SYS:java.lang.RuntimePermission’, ‘writeFileDescriptor’, ”);
EXEC DBMS_JAVA.grant_permission(‘SCHEMA-NAME’, ‘SYS:java.lang.RuntimePermission’, ‘readFileDescriptor’, ”);

Comments»

no comments yet - be the first?