Check the user having SYSDBA Privileges in Oracle
Find the user having sysdba or sysopera privileges
select username,sysdba,sysoper,sysasm,sysbackup,sysdg,syskm from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM -------------------- ----- ----- ----- ----- ----- ----- SYS TRUE TRUE FALSE FALSE FALSE FALSE SYSDG FALSE FALSE FALSE FALSE TRUE FALSE SYSBACKUP FALSE FALSE FALSE TRUE FALSE FALSE SYSKM FALSE FALSE FALSE FALSE FALSE TRUE
Find the user according to container id in Oracle 12c
Note: You can check the common user from common column for Oracle 12c this common user means that these super users can login to any PDB database and CDB.
SQL> select username,sysdba,sysoper,sysasm,sysbackup,sysdg,syskm,common,con_id from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM COM CON_ID -------------------- ----- ----- ----- ----- ----- ----- --- ---------- SYS TRUE TRUE FALSE FALSE FALSE FALSE YES 0 SYSDG FALSE FALSE FALSE FALSE TRUE FALSE YES 0 SYSBACKUP FALSE FALSE FALSE TRUE FALSE FALSE YES 0 SYSKM FALSE FALSE FALSE FALSE FALSE TRUE YES 0
Smart way of Technology 