Find which user has SYSDBA and DBA privilege

Find which user has SYSDBA and DBA privilege

DBA-----DBA_ROLE_PRIVS
SYSDBA------v$pwfile_users


select * from dba_role_privs where granted_role='DBA';

SELECT * FROM v$pwfile_users WHERE sysdba='TRUE';