Dynamic Performance (V$) Views, 112 of 179

V$PWFILE_USERS

This view lists users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.

Column Datatype Description

USERNAME

VARCHAR2(30)

The name of the user that is contained in the password file

SYSDBA

VARCHAR2(5)

If the value of this column is TRUE, the user can connect with SYSDBA privileges

SYSOPER

VARCHAR2(5)

If the value of this column is TRUE, the user can connect with SYSOPER privileges

Column	Datatype	Description
`USERNAME`	`VARCHAR2(30)`	The name of the user that is contained in the password file
`SYSDBA`	`VARCHAR2(5)`	If the value of this column is TRUE, the user can connect with SYSDBA privileges
`SYSOPER`	`VARCHAR2(5)`	If the value of this column is TRUE, the user can connect with SYSOPER privileges