To enable a developer to have the right to debug any stored procedure in the database, we need to grant the following system privileges to it.
DEBUG CONNECT SESSION
DEBUG CONNECT SESSION is used to make the user connect the current session to a debugger.
SQL> grant DEBUG CONNECT SESSION to hr;
Grant succeeded.
DEBUG ANY PROCEDURE
DEBUG ANY PROCEDURE is used to enable the user to debug all PL/SQL and Java code in any database object.
SQL> grant DEBUG ANY PROCEDURE to hr;
Grant succeeded.
Then we can notify the user to test it.
Chances are, it may run into another ACL problem when connecting to a debugger.