Oracle 用戶密碼

下面的代碼適用於

當用戶被鎖

當用戶的密碼不可知,但需要用戶身份執行的時候,可以更改密碼,並根據dba_user 的表修改回去,前提是需要sysdba身份

D:Documents and Settingsguanhao>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 11月 23 13:41:32 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn /as sysdba
已連接。
SQL> alter user scott account unlock;                         #對實驗用戶scott解鎖,原始密碼是tiger,假設為知

用戶已更改。

SQL> select username,passWord from dba_users;

USERNAME                       PASSWord
------------------------------ ------------------------------
MGMT_VIEW                      3421676E89FE4F77
SYS                            6F6CDB5C0770FAE3
SYSTEM                         2D594E86F93B17A1
DBSNMP                         FFF45BB2C0C327EC
SYSMAN                         867F7B3AF90F67C2
SCOTT                          F894844C34402B67                                    #記錄下現在SCOTT用戶的密碼
SERVICE2007                    226306A10F9B061F
OUTLN                          4A3BA55E08595C81
MDSYS                          72979A94BAD2AF80
ORDSYS                         7EFA02EC7EA6B86F
CTXSYS                         71E687F036AD56E5
USERNAME                       PASSWord
------------------------------ ------------------------------
ANONYMOUS                      anonymous
EXFSYS                         66F4EF5650C20355
DMSYS                          BFBA5A553FD9E28A
WMSYS                          7C9BA362F8314299
XDB                            88D8364765FCE6AF
ORDPLUGINS                     88A2B2C183431F00
SI_INFORMTN_SCHEMA             84B8CBCA4D477FA3
OLAPSYS                        3FB8EF9DB538647C
MDDATA                         DF02A496267DEE66
DIP                            CE4A36B8E06CA59C
TSMSYS                         3DF26A8B17D0F29F

已選擇22行。

SQL> alter user scott identifIEd by ghghgh;                                               #修改新的密碼

用戶已更改。

SQL> select username,passWord from dba_users;

USERNAME                       PASSWord
------------------------------ ------------------------------
MGMT_VIEW                      3421676E89FE4F77
SYS                            6F6CDB5C0770FAE3
SYSTEM                         2D594E86F93B17A1
DBSNMP                         FFF45BB2C0C327EC
SYSMAN                         867F7B3AF90F67C2
SCOTT                          FB96463EC88AC2FB                                              #你會發現已經更改密碼
SERVICE2007                    226306A10F9B061F
OUTLN                          4A3BA55E08595C81
MDSYS                          72979A94BAD2AF80
ORDSYS                         7EFA02EC7EA6B86F
CTXSYS                         71E687F036AD56E5

USERNAME                       PASSWord
------------------------------ ------------------------------
ANONYMOUS                      anonymous
EXFSYS                         66F4EF5650C20355
DMSYS                          BFBA5A553FD9E28A
WMSYS                          7C9BA362F8314299
XDB                            88D8364765FCE6AF
ORDPLUGINS                     88A2B2C183431F00
SI_INFORMTN_SCHEMA             84B8CBCA4D477FA3
OLAPSYS                        3FB8EF9DB538647C
MDDATA                         DF02A496267DEE66
DIP                            CE4A36B8E06CA59C
TSMSYS         ;                3DF26A8B17D0F29F

已選擇22行。

SQL> conn scott/ghghgh                                                                               #連接成功
已連接。
SQL> conn /as sysdba
已連接。
SQL> alter user scott identifIEd by values ''F894844C34402B67'';         #用sys用戶修改回原來的密碼

用戶已更改。

SQL> conn scott/ghghgh
ERROR:
ORA-01017: invalid username/passWord; logon denIEd


警告: 您不再連接到 Oracle。
SQL> conn scott/tiger
已連接。
SQL>

用法總結:

alter user scott identifIEd by

alter user scott identifIEd by values