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.

Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐