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/