Search notes:

Oracle: V$PWFILE_USERS

v$pwfile_users lists all users who have been granted *adminstrative privileges*j (SYSDBA, SYSOPER, SYSBACKUP, SYSDG and/or SYSKM) privileges:

select
   username,
   --
   sysdba,
   sysoper,
   sysasm,
   sysbackup,
   sysdg,
   syskm,
   --
   account_status,
   password_profile,
   last_login,
   lock_date,
   expiry_date,
   external_name,
   authentication_type,
   common,
   password_versions,
   con_id
from
   v$pwfile_users;

The following query selects all users who have been granted the SYSDBA privilege:

select
   username
from
   v$pwfile_users
where
   username != 'SYS'   and
   sysdba    = 'TRUE';

Oracle: V$PWFILE_USERS

See also