Knowledge Base : List Users with SYSDBA privileges

Generate list of users with SYSOPER or SYSDBA privileges

SQL> select * from V$PWFILE_USERS;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
SYS                            TRUE  TRUE
SYSTEM                         FALSE TRUE
ENG001                         FALSE TRUE