Return
-
Title
Privileges needed for the TOAD debugger -
Description
What privileges are needed for the TOAD debugger?
-
Resolution
Here are the privileges for the TOAD debugger.
A. GRANT ALTER SESSION TO user_name;
B. GRANT CREATE SESSION TO user_name;
C. GRANT EXECUTE ON SYS.DBMS_DEBUG TO PUBLIC;
D. GRANT ALTER ANY PROCEDURE TO user_name; (compile)
E. GRANT CREATE ANY PROCEDURE TO user_name; (edit/save)
For Oracle 10G, the following additional grant is required:
F. GRANT DEBUG CONNECT SESSION TO user_name;
G. GRANT DEBUG ANY PROCEDURE TO user_name;
Also, verify that the dbms_debug package in the sys schema is valid.