Toad World® Forums

Unable to use PL/SQL Debugger

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.

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