oracle中授予XXX权限

sqlplus / as sysdba;

grant create view to 用户名;

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