今天一开发同事反应新建的测试用户无法执行存储过程，使用plsq远程连接执行存储过程报错如下：
报错信息是：ORA-0131：Insufficient privileges，就是用户没有存储过程的调试执行权限：DEBUG CONNECT SESSION
需要具有DBA权限的用户登录授权即可：
报错信息是：ORA-0131：Insufficient privileges，就是用户没有存储过程的调试执行权限：DEBUG CONNECT SESSION
需要具有DBA权限的用户登录授权即可：
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Connected as test29@Audit11g31Server
SQL> conn zhul/zhulei
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Connected as zhul@Audit11g31Server
SQL> grant DEBUG CONNECT SESSION to test29;
Grant succeeded
SQL> grant DEBUG CONNECT SESSION to bmi_xbsh;
Grant succeeded
SQL> grant DEBUG CONNECT SESSION to bmi_cs01;
Grant succeeded
SQL> grant DEBUG CONNECT SESSION to bmi_cs02;
Grant succeeded
SQL>
授权完成后，测试用户再次执行存储过程可以正常执行了。
Connected as test29@Audit11g31Server
SQL> conn zhul/zhulei
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Connected as zhul@Audit11g31Server
SQL> grant DEBUG CONNECT SESSION to test29;
Grant succeeded
SQL> grant DEBUG CONNECT SESSION to bmi_xbsh;
Grant succeeded
SQL> grant DEBUG CONNECT SESSION to bmi_cs01;
Grant succeeded
SQL> grant DEBUG CONNECT SESSION to bmi_cs02;
Grant succeeded
SQL>
授权完成后，测试用户再次执行存储过程可以正常执行了。
![[MySQL]存储过程](https://ucc.alicdn.com/3mfxe2r26qbaq/developer-article1632621/20241101/f9e47d1cdc9947d492b09f397a02c7b6.jpeg?x-oss-process=image/resize,h_160,m_lfit)
![2024Mysql And Redis基础与进阶操作系列（9）作者——LJS[含MySQL存储过程之局部、系统变量、参数传递、流程控制-判断/case具体详步骤；注意点及常见报错问题所对应的解决方法]](https://ucc.alicdn.com/pic/developer-ecology/56pfyutwi4tv4_c53df19098d2427391fe36eeb35f84c8.png?x-oss-process=image/resize,h_160,m_lfit)