Return
-
Title
ORA-01031: insufficient privileges while using the SYS.DBMS_DEBUG_JDWP Builtin -
Description
Toad
While trying to debug using the SYS.DBMS_DEBUG_JDWP Builtin user gets the following error messages:
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 2
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 2 -
Resolution
The Java debugger built in for 9i requires the following GRANTS to be given to the user:
GRANT EXECUTE ON SYS.DBMS_DEBUG_JDWP TO <username/schema>;
GRANT DEBUG CONNECT SESSION TO <username/schema>;
GRANT DEBUG ANY PROCEDURE TO <username/schema>;
Close and restart TOAD.