Oracle查看那些用户具有DBA权限「建议收藏」

col GRANTEE for a20
col granted_role for a20
select * from sys.dba_role_privs where granted_role='DBA';

GRANTEE              GRANTED_ROLE         ADM DEL DEF COM INH
-------------------- -------------------- --- --- --- --- ---
AAA_DBA             DBA                  NO  NO  YES NO  NO
SBBB            DBA                  NO  NO  YES NO  NO
CCC               DBA                  NO  NO  YES NO  NO
DD                   DBA                  NO  NO  YES NO  NO
DDD                DBA                  YES NO  YES NO  NO
ADE               DBA                  NO  NO  YES NO  NO
DQERG                 DBA                  NO  NO  YES NO  NO
GEA             DBA                  NO  NO  YES NO  NO
DFQET            DBA                  NO  NO  YES NO  NO
AERG                DBA                  NO  NO  YES NO  NO
ERQG                 DBA                  NO  NO  YES NO  NO

...

22 rows selected.