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';