V$PWFILE_USERS

V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, and SYSASM privileges.

Column	Datatype	Description
`USERNAME`	`VARCHAR2(30)`	Name of the user that is contained in the password file
`SYSDBA`	`VARCHAR2(5)`	Indicates whether the user can connect with `SYSDBA` privileges (`TRUE`) or not (`FALSE`)
`SYSOPER`	`VARCHAR2(5)`	Indicates whether the user can connect with `SYSOPER` privileges (`TRUE`) or not (`FALSE`)
`SYSASM`	`VARCHAR2(5)`	Indicates whether the user can connect with `SYSASM` privileges (`TRUE`) or not (`FALSE`)