oracle - ORA-0131 :insufficient privileges DEBUG CONNECT SESSION

Question

我在尝试使用 PL/SQL Developer 启动调试 PL/SQL 脚本时收到此错误消息“ORA-0131:权限不足 DEBUG CONNECT SESSION”。

Oracle 数据库 11g 版本 11.1.0.7.0

我是管理员组的一员。这个权限有必要吗？

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

Answer 1

正如你提到的，它的特权问题。
引自此 site

ORA-01031: insufficient privileges

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

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

如果你在调试它应该工作

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