Re: JAVA file permissions

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Mon, 13 Jul 2009 00:41:38 -0700 (PDT)
Message-ID: <a1000b20-500d-4273-b8db-2ea528e9328b_at_f30g2000vbf.googlegroups.com>

On Jul 7, 7:07�pm, CenturionX <darwinbaldr..._at_gmail.com> wrote:
> Hello,
>
> 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.

Hth,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Mon Jul 13 2009 - 02:41:38 CDT