V$PWFILE_USERS lists users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.
| 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) |