今天开发的同事打电话来说不能对Procedure做debug具体的出错信息如下: 从出错信息就可以知道如何做了.直接授权就可以.

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
This session requires DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE user privileges.
Process exited. 解决方案如下:

[@more@]

Connect to the default database as SYSTEM.

Run "GRANT debug any procedure, debug connect session TO XX;".

Re-connect to the default database as XX.

ITPub博客

Tips--How To Assign Debug Privileges to a User

最新文章