v$pwfile_user表

SQL> select * from v$pwfile_users;
select * from v$pwfile_users;

USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE FALSE

SQL>

但是，在12c中，又发生了变化：

V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM,SYSBACKUP, SYSDG, and SYSKM 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`)
`SYSBACKUP`	`VARCHAR2(5)`	Indicates whether the user can connect with `SYSBACKUP` privileges (`TRUE`) or not (`FALSE`)
`SYSDG`	`VARCHAR2(5)`	Indicates whether the user can connect with `SYSDG` privileges (`TRUE`) or not (`FALSE`)
`SYSKM`	`VARCHAR2(5)`	Indicates whether the user can connect with `SYSKM` privileges (`TRUE`) or not (`FALSE`)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data