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.

 

ColumnDatatypeDescription
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
posted @ 2014-01-20 15:59  健哥的数据花园  阅读(1050)  评论(0)  编辑  收藏  举报