Problem:
Getting the following error when debugging a function under GENEVA_DATA user in hostname:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Solution:
How to start a debug session in SQL Developer?
There are some prerequisites, it won’t take but a few moments to setup.
Ensure that
Getting the following error when debugging a function under GENEVA_DATA user in hostname:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Solution:
How to start a debug session in SQL Developer?
There are some prerequisites, it won’t take but a few moments to setup.
Ensure that
- you have been granted the DEBUG CONNECT SESSION priv
- you have EXECUTE privs on DBMS_JDWP_DEBUG.
- you have EXECUTE privs on the object you want to debug
