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