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;;
Comments
Tags: DEBUG CONNECT SESSION, Debugging requires the DEBUG CONNECT, Insufficient, Insufficient privileges, ORA Debugging, ORA Debugging requires, Ora Error, ORA-0131, ORA-0131: Insufficient privileges, Oracle APPs DBA, ORACLE DB, Oracle DBA, privileges, system privilege