sys.user$ 记录用户密码





如果不知道用户的密码可以查sys.user$ ，记下，修改密码，以后还可以再改回原来的，即使不知道原密码是什么

SQL> select name,password from sys.user$   where name='SCOTT';

NAME                                                                                       PASSWORD
------------------------------------------------------------------------------------------ ------------------------------
SCOTT                                                                                     F894844C34402B67

SQL> conn / as sysdba

Connected.

SQL> alter user scott identified by tiger123;

User altered.

SQL> conn scott/tiger123
Connected.

SQL> conn / as sysdba
Connected.

SQL> select name,password from sys.user$ where name='SCOTT';

NAME                                                                                       PASSWORD
------------------------------------------------------------------------------------------ ------------------------------
SCOTT                                                                                      0CF421ECB3EFCC4E

SQL> alter user scott identified by values 'F894844C34402B67';

User altered.

SQL> conn scott/tiger
Connected.