Re: Java Stored Procedure

Julien,

I went through this excercise last week, but I didn't specify the permission type as being owned by SYS. Try using just 'java.util.PropertyPermission'.

I don't know what you are doing specifically, but don't be surprised if this is the first of a handful of permissions that need to be set. My personal experience revealed that there were three permmissions that I had to grant. Your mileage may vary.

Rich

Julien Reynier wrote:

> Hi,
>
> I would like to load a Java Stored Procedure in Oracle 8i (8.1.6).
> But when I try to load it I obtain this error :
> ORA-29536: bad source : java.security.AccessControlException: the
> Permission (java.util.PropertyPermission line.separator read) has not
> been
> granted by dbms_java.grant_permission to
> SchemaProtectionDomain(JULIENR|PolicyTableProxy(JULIENR))
>
> so I log as SYS and I try to grant java permission but I obtain an other
> error message:
> CALL
> DBMS_JAVA.GRANT_PERMISSION('JULIENR','SYS:java.util.PropertyPermission','line.separator','read')
> *
> ERREUR at line 1 :
> ORA-29532: Java call terminated by uncaught Java exception :
> java.lang.SecurityException: policy table update
> SYS:java.util.PropertyPermission, line.separator
>
> Any solution...
> Thanks...
>
> Julien Reynier
Received on Sat Jun 23 2001 - 11:48:14 CDT