oracle ORA-0131 : 权限不足 DEBUG CONNECT SESSION

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/30588754/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-09 00:52:36  来源:igfitidea点击:

ORA-0131 :insufficient privileges DEBUG CONNECT SESSION

oracledebuggingplsql

提问by Moudiz

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

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

Oracle Database 11g Release 11.1.0.7.0

Oracle 数据库 11g 版本 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>

回答by Moudiz

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>