Find users with DBA privilege

SQL> select * from dba_role_privs where granted_role='DBA';

GRANTEE                   GRANTED_ROLE        ADMIN_OPTION        DEFAULT_ROLE

------------------------- --------------- --------- ---------------------------------- --------------- --------- -

SYS                                  DBA                             YES                                 YES

SYSTEM                          DBA                             YES                                 YES

Comments