如何查询具有某个角色的所有用户？

[helysan]

同题目

[bzszp]

SQL> select * from DBA_ROLE_PRIVS where GRANTED_ROLE='RESOURCE';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
AURORA$JIS$UTILITY$ RESOURCE NO YES
CTXSYS RESOURCE NO YES
DBSNMP RESOURCE NO YES
MTSSYS RESOURCE NO YES
ORDPLUGINS RESOURCE NO YES
ORDSYS RESOURCE NO YES
OSE$HTTP$ADMIN RESOURCE NO YES
OUTLN RESOURCE NO YES
PLATE RESOURCE NO YES
SCOTT RESOURCE NO YES
SYS RESOURCE YES YES

已选择11行。

已用时间: 00: 00: 00.71
SQL>