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:
|
本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/3527084.html，如需转载请自行联系原作者
