ORA-0131:Insufficient privileges.(DEBUG CONNECT SESSION)

ORA-0131:Insufficient privileges.

Note:Debugging requires the DEBUG CONNECT SESSION system privileges

[@more@]

后经查找，是缺失 DEBUG CONNECT SESSION 系统权限所致。

解决办法：以SYS用户登录数据库，执行赋权操作：

SQL> grant DEBUG CONNECT SESSION to user_name;

不需要赋予DEBUG ANY PROCEDURE 也可以的。

SQL> conn / as sysdba;

Connected.

SQL> select * from role_sys_privs where privilege like 'DEBUG%' order by 2;

ROLE PRIVILEGE ADM

---------------- ------------------------ ---

DBA DEBUG ANY PROCEDURE YES

JAVADEBUGPRIV DEBUG ANY PROCEDURE NO

DBA DEBUG CONNECT SESSION YES

JAVADEBUGPRIV DEBUG CONNECT SESSION NO

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-1060991/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1060991/