Unable to use PL/SQL Debugger

SQL Navigator
1

Hello,

We are licensed for PL/SQL Debugger. However, when I attempt to use it, I receive the following errors:

ORA-01031: insufficient privileges
ORA-06512: at “SYS.PBSDE”, line 78
ORA-06512: at “SYS.DBMS_DEBUT”, line 224
ORA-06512: at line 1

It appears that our installation was not completed correctly. Please advise what needs to be done to resolve this error.

2

Hi Kit,

Your problem has nothing to do with the SQL Navigator licensing or installation; it appears that your Oracle account doesn’t have enough privileges. You need to ask your DBA to grant you privileges DEBUG ANY PROCEDURE and DEBUG CONNECT SESSION.

Hope this helps,
Roman