oracle – ORA-0131：权限不足DEBUG CONNECT SESSION

发布时间：2020-12-12 16:26:11 所属栏目：百科来源：网络整理

导读：我收到此错误消息“ORA-0131：权限不足DEBUG CONNECT SESSION”尝试使用PL / SQL Developer启动调试PL / SQL脚本. Oracle Database 11g 11.1.0.7.0版我是管理员组的一员.这种特权是否必要？ grant DEBUG CONNECT SESSION to =bobens_83-here_goes_your_db-u

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

Oracle Database 11g 11.1.0.7.0版

我是管理员组的一员.这种特权是否必要？

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

正如你所提到的,它的特权问题.

引自这个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.

如果您正在进行调试,它应该工作

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!