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:
|