Required Debugging Database Privileges

To debug a PL/SQL object, you must have the following privilege:

DEBUG CONNECT SESSION

You also need DEBUG and EXECUTE privileges on SYS.DBMS_DEBUG_JDWP, which is the package used to start or stop the debug session.

If the PL/SQL object to debug belongs to you, no further privileges are required.

If the PL/SQL object does not belong to you, then you must be granted DEBUG and EXECUTE privileges on the PL/SQL object.