oracle查看用户属于哪个role


'查看username属于哪个role
select * from dba_role_privs where grantee=upper('username');
'查看rolename拥有哪些权限
select * from dba_sys_privs where grantee=upper('rolename');