ORA-0131:debugging requires the debug connect session system privilege
来源:互联网 发布:50而知天命的英文翻译 编辑:程序博客网 时间:2024/05/19 23:26
今天在进行procedure执行的时候,用的是PL/SQL工具中的test,调试方法进行执行,因为有输入参数,但是报了个错:
“note:debugging requires the debug connect session system privilege”.
原因是用户权限不够,使用以下命令授予权限:
GRANT debug any procedure, debug connect session TO username
其实只需要授予debug connect session 就可以了,已经过测试。
另外,如果查询某个角色包含哪些系统权限的话,可以查询:
(1)、系统权限:
select * from role_sys_privs;
ROLE_SYS_PRIVSROLE_SYS_PRIVS:describes system privileges granted to roles. Information is provided only about roles to which the user has access
(2)、对象权限:
select * from role_tab_privs;
ROLE_TAB_PRIVSROLE_TAB_PRIVS:describes table privileges granted to roles. Information is provided only about roles to which the user has access.
(3)、角色里都包含哪些角色:
select * from role_role_privs
ROLE_ROLE_PRIVSROLE_ROLE_PRIVS:describes the roles granted to other roles. Information is provided only about roles to which the user has access.
参考文献:1. http://space.itpub.net/23230551/viewspace-661979
- ORA-0131:debugging requires the debug connect session system privilege
- 用pl/sql developer 调试存储过程报错(debugging requires the debug connect session system privilege)
- debug privilege
- ORA-01035: only available to users with RESTRICTED SESSION privilege
- ORA-01045: user DEMO lacks CREATE SESSION privilege; logon denied
- ORA-01045: user lacks CREATE SESSION privilege; logon denied
- 解决:ORA-01045:user * lacks CREATE SESSION privilege;logon denied
- ORA-01045: user lacks CREATE SESSION privilege; logon denied
- ORA-01045: user lacks CREATE SESSION privilege; logon denied
- oracle创建用户ORA-01045:user lacks CREATE SESSION privilege;
- ORA-01045: user lacks CREATE SESSION privilege解决办法
- ORA-01045: user lacks CREATE SESSION privilege; logon denied
- ORA-01045: user lacks CREATE SESSION privilege; logon denied
- ORA-01045:user lacks CREATE SESSION privilege;logon denied
- ORA-01045: user lacks CREATE SESSION privilege; logon denied
- System.Data.OracleClient.OracleException:ORA-12154: TNS:could not resolve the connect identifier spe
- [CUJ] Debugging With The 80386 Hardware Debug Registers
- sqlplus 出现ORA——01045:user USERNAME locks CREATE SESSION privilege : login denied
- React Native的iOS开发步骤以及崩溃收集
- js入门必读--和你分享js的学习之路1
- 无线循环的两种方式
- android开发类似淘宝京东头条的垂直跑马灯效果
- lightOJ 1068 - Investigation (数位dp)
- ORA-0131:debugging requires the debug connect session system privilege
- 禁用myeclipse updating indexes与大幅优化myeclipse的速度&关闭自动更新
- AbstractList抽象类源码解析
- redis.clients.jedis.exceptions.JedisConnectionException: Could not get a resource from the pool
- android如何编译出适用于不同平台的库文件
- 关于HTML标签的反转义函数
- java 单利模式
- mysql 行转列,套路版
- [Leetcode] Container With Most Water 能装最大水的容量