Re: JAVA file permissions
Date: Mon, 13 Jul 2009 00:41:38 -0700 (PDT)
On Jul 7, 7:07 pm, CenturionX <darwinbaldr..._at_gmail.com> wrote:
> I'm working with ORACLE 10.2.0.4.0 on windows server 2003 R2.
> I need to execute a DOS batch file. I used some code i found in the
> web (see the code below).
> When i try to give permission to execut ethe file:
> EXEC DBMS_JAVA.grant_permission('CMS',
> 'SYS.java.io.FilePermission', 'K:\Mesr\DBP_EXEC_FROM_ORA\',
> 'read ,write, execute');
> I get this error:
> ORA-29532: Java call terminated by uncaught Java exception:
> java.lang.ClassNotFoundException: sys/java/io/filepermission
> ORA-06512: at "SYS.DBMS_JAVA", line 313
> ORA-06512: at line 1
> Somebody has a good idea on this.
This call should look like this:
EXEC DBMS_JAVA.grant_permission('CMS', 'SYS:java.io.FilePermission', 'K:\Mesr\DBP_EXEC_FROM_ORA\', 'read ,write, execute');
that is, replace the dot after SYS with colon in the permission class name.
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Mon Jul 13 2009 - 02:41:38 CDT