如果不知道用户的密码可以查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.