CODEWITHSUNDEEP
oracle-databasedebuggingplsql
user4420255
user4420255

Reputation:

ORA-0131 :insufficient privileges DEBUG CONNECT SESSION

I got this error message "ORA-0131 :insufficient privileges DEBUG CONNECT SESSION" trying to start debug PL/SQL script using PL/SQL Developer.

Oracle Database 11g Release 11.1.0.7.0

I'm a part of admin group. Is this privileges necessary?

grant DEBUG CONNECT SESSION to =<bobens_83-here_goes_your_db-username>

Upvotes: 12

Views: 73703

Answers (1)

Moudiz
Moudiz

Reputation: 7377

As you mentioned , its problem of privileges.

Quoted from this site

ORA-01031: insufficient privileges

Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the
current login.

Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the appropriate privilege at a higher label, ask the database administrator to re-grant the privilege at the appropriate label.

If you working on debug it should work

grant DEBUG CONNECT SESSION to <bobens_83-here_goes_your_db-username>

Upvotes: 18

Related Questions