One of the most frequently posed Oracle basic interview questions, be ready for it. To acquire information about the existing users in the password file, use the "v$pwfile users" view. Run the SQL query below:  SELECT * FROM v$pwfile users in sql;  For each user in the password file, the query above will return four columns. USERNAME, SYSDBA, SYSOPER, and SYSASM are the column names.  The USERNAME field displays the user's username from the password file.  The SYSDBA field indicates whether or not the user has SYSDBA rights.  The SYSOPER field indicates whether or not the user has SYSOPER rights.  The SYSASM field indicates whether or not the user has SYSASM rights.