Skip to content

How to Resolve ORA-0131: insufficient privileges in PL/SQL Developer

  • by
ORA-0131 in PL/SQL Developer

ORA-0131

A developer reported a weird error ORA-0131 when connect to the database in PL/SQL developer.

In fact, there's no ORA-0131 such error in Oracle database. I think it's a typo of ORA-01031: insufficient privileges.

Solution

To enable users to call DBMS_DEBUG in their session time, we have to grant DEBUG CONNECT SESSION privilege to the users.

SQL> grant debug connect session to scott;

Grant succeeded.

Problem solved.

Leave a Reply

Your email address will not be published.