DBMS_JAVA.GRANT_PERMISSION 'SYS:JAVA.NET.SOCKETPERMISSION' has not been granted
(Doc ID 1082251.1)
Last updated on SEPTEMBER 01, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
Executing a java stored procedure (JSP) may fail with:
Exception -->java.security.AccessControlException:
the Permission (java.net.SocketPermission <hostname.net> resolve) has not been granted to '<schema>'.
The PL/SQL to grant this is dbms_java.grant_permission( '<schema>','SYS:java.net.SocketPermission', 'siebeldev.emdeon.net', 'resolve' )
Executing the following to assign the permission to the user results in the same exception.
SQL> exec dbms_java.grant_permission( '<SCHEMA>','SYS:java.net.SocketPermission', '<HOSTNAME>', 'resolve,connect');
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |