Re: dbms_java.grant_permission
Date: 4 Jul 2002 01:13:27 -0700
Message-ID: <9885fbd8.0207040013.d8702ff_at_posting.google.com>
You don't have the correct rights set
log in as a user who has the permission to manage the policy table (PolicyTablePermission). Normally this will be in the java_admin role. This role is usually granted to the dba group.
then run following code
begin
dbms_java.grant_permission
( 'USER_NEEDING_THIS_PERMISSION',
'java.util.PropertyPermission',
'YOUR_DIRECTORY',
'read'
);
END; see http://java.sun.com/j2se/1.3/docs/api/java/util/PropertyPermission.html for more information
"REM" <ilica.brnadic_at_zg.hinet.hr> wrote in message news:<afvlf6$1ihh$1_at_as201.hinet.hr>...
> How I can resolve this problem??
>
> SQL> exec dbms_java.loadjava('plsql/jlib/plsql.jar');
> BEGIN dbms_java.loadjava('plsql/jlib/plsql.jar'); END;
>
> *
> ERROR at line 1:
> ORA-29532: Java call terminated by uncaught Java exception:
> java.security.AccessControlException:
> the Permission (java.util.PropertyPermission
> oracle.aurora.rdbms.oracle_home
> read) has not been
> granted by dbms_java.grant_permission to
> SchemaProtectionDomain(SYS|PolicyTableProxy(SYS))
> ORA-06512: at "SYS.DBMS_JAVA", line 0
> ORA-06512: at line 1
Received on Thu Jul 04 2002 - 10:13:27 CEST