ORA-0131:debugging requires the debug connect session system privilege

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