12查看用户拥有哪些角色sql>select * from dba_role_privs where granted_role='ITPUX_ROLE'; --ITPUX_ROLE(角色)sql>select granted_role,grantee from dba_role_privs where grantee='xiong'; 02:13:19 SYS@db01> SELECT GRANTED_ROLE,GRANTEE FROM DBA_ROLE_PRIVS where GRANTEE='XIONG';GRANTED_ROLE（授予哪个角色给用户） GRANTEE（被授予角色的用户）------------------------------ ------------------------------ITPUX_ROLE XIONGCONNECT XIONG