Oracle RDS GRANT ISSUE for java.protocol.handler.pkgs

Question

Error while when executing exec dbms_java.grant_permission('myschema','SYS:java.util.PropertyPermission','java.protocol.handler.pkgs','write');

Error Details : 
ORA-29532: Java call terminated by uncaught Java exception: java.lang.SecurityException: policy table update SYS:java.util.PropertyPermission, java.protocol.handler.pkgs
ORA-06512: at "SYS.DBMS_JAVA", line 705
ORA-06512: at line 1
29532. 00000 -  "Java call terminated by uncaught Java exception: %s"
*Cause:    A Java exception or error was signaled and could not be
           resolved by the Java code.

Answer

Java implementation in Amazon RDS has a limited set of permissions. The master user is granted the RDS_JAVA_ADMIN role, which grants a subset of the privileges granted by the JAVA_ADMIN role. java.util.PropertyPermission in RDS Oracle is limited to http.* and https.*
You can see the permissions it has by looking into the permissions granted to RDS_JAVA_ADMIN role using this query

SELECT name FROM dba_java_policy 
   WHERE grantee IN ('RDS_JAVA_ADMIN', 'PUBLIC') 
   AND enabled = 'ENABLED' 
   ORDER BY type_name, name, grantee;

If you must use this functionality in Oracle database, you can consider Amazon RDS Custom for Oracle  https://aws.amazon.com/rds/custom/

Oracle RDS GRANT ISSUE for java.protocol.handler.pkgs

相关内容