Friday, February 6, 2015

Debugging requires the DEBUG CONNECT SESSION system privilege


Error : Issue with Debugging using PL/SQL Developer


ORA - 0131: Insufficient privilegesNote: Debugging requires the DEBUG CONNECT SESSION system privilege


Solution : 

grant DEBUG CONNECT SESSION to  <user_name> ;
grant DEBUG ANY PROCEDURE to <user_name>  ;

Ex User is apps :

SQL> grant DEBUG CONNECT SESSION to apps;

Grant succeeded.

SQL> grant DEBUG ANY PROCEDURE to apps;

Grant succeeded.

SQL> exit:

No comments:

Post a Comment