When trying to debug a procedure, package, etc., the following error messages are received:
1:12:56 PM ORA-01031: insufficient privileges
1:12:56 PM ORA-06512: at "SYS.PBSDE", line 78
1:12:56 PM ORA-06512: at "SYS.DBMS_DEBUG", line 224
1:12:56 PM ORA-06512: at line 1
The Oracle user or schema account does not have the required Oracle rights to debug an object.
Ensure the User or Schema has all the required Oracle privileges granted for debugging objects on that database.
The following privileges are required for the Debugger in Oracle 9i:
1. GRANT ALTER SESSION TO user_name;
2. GRANT CREATE SESSION TO user_name;
3. GRANT EXECUTE ON DBMS_DEBUG to user_name;
* If DBMS_DEBUG is missing, have a DBA User run PRVTPB.PLB (C:\Oracle\Admin\prvtpb.plb)
* Also, verify that the DBMS_DEBUG package in the SYS schema is valid.
The following privileges are required (IN ADDITION TO THE ABOVE) for the Debugger in Oracle 10g:
1. GRANT DEBUG ANY PROCEDURE TO user_name;
2. GRANT DEBUG CONNECT SESSION TO user_name;
Minimum requirements to Debug other than your own procedures, functions, and packages:
1. GRANT ALTER ANY PROCEDURE TO user_name; (compile)
2. GRANT CREATE ANY PROCEDURE TO user_name; (edit / save)
After the above, exit and restart SQL Navigator.
