One
can select from SYS.V_$PWFILE_USERS view to see which users are listed in the
password file.
New users can be added to the password file by granting them
SYSDBA or SYSOPER privileges or by using the orapwd utility.
SQL>GRANT
SYSDBA TO Scott;
