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

Question

同题目

Answer 1

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>