Information
The JAVADEBUGPRIV privilege allows debugging of Java stored procedures within the Oracle database. Debugging privileges can potentially be exploited to inspect or alter Java code execution. Revoking this privilege from unauthorized users helps prevent unauthorized debugging of Java stored procedures and reduces the risk of exposing internal Java code logic.
Unauthorized granting of the JAVADEBUGPRIV privilege may expose Java procedures to unintended debugging, which can lead to security risks such as unauthorized access or code manipulation.
Solution
To remediate this setting, execute the following SQL statement, keeping in mind if this is granted in both container and pluggable database, you must connect to both places to revoke. Please ensure proper impact analysis is done before revoking the privilege from a role.
REVOKE JAVADEBUGPRIV FROM <grantee>;
In the case of a grant via a role:
REVOKE <rolename> FROM <grantee>;