Title :
Getting “ORA-01031: insufficient privileges” error when trying to Debug.
Description :
When trying to debug a procedure, package, etc., the following error messages are received:
ORA-01031: insufficient privileges
Cause :
The Oracle user or schema account does not have the required Oracle rights to debug an object.
Resolution :
Ensure the User or Schema has all the required Oracle privileges granted for debugging objects on that database.
1. connect as sysdba
2. exec the sql:
grant debug connect session to XXXXXX;
or
grant DEBUG ANY PROCEDURE to XXXXXX;;