oracle procedure 权限

今天在进行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