oracle 12c 密码文件包括很多用户的密码

密码认证都:默认是存在密码文件:

SQL> select USERNAME,SYSDBA,SYSOPER,SYSASM,SYSBACKUP,SYSDG,SYSKM,ACCOUNT_STATUS from V$PWFILE_USERS;
USERNAME             SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM ACCOUNT_STATUS
-------------------- ----- ----- ----- ----- ----- ----- ------------------------------
SYS                  TRUE  TRUE  FALSE FALSE FALSE FALSE OPEN
SYSDG                FALSE FALSE FALSE FALSE TRUE  FALSE OPEN
SYSBACKUP            FALSE FALSE FALSE TRUE  FALSE FALSE OPEN
SYSKM                FALSE FALSE FALSE FALSE FALSE TRUE  OPEN
OGGTEMP              TRUE  FALSE FALSE FALSE FALSE FALSE OPEN
SQL> select USERNAME,ACCOUNT_STATUS from dba_users where ACCOUNT_STATUS='OPEN';
USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SYS                            OPEN
SYSTEM                         OPEN
C##TEST01                      OPEN

看出上述奇特没有
重新创建密码文件如下,创建命令见前面文章

SQL> 
USERNAME             SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM ACCOUNT_STATUS
-------------------- ----- ----- ----- ----- ----- ----- ------------------------------
SYS                  TRUE  TRUE  FALSE FALSE FALSE FALSE OPEN
SYSDG                FALSE FALSE FALSE FALSE TRUE  FALSE OPEN
SYSDG                FALSE FALSE FALSE FALSE TRUE  FALSE OPEN
This entry was posted in 学习. Bookmark the permalink.