Oracle user password Modification Scheme

In actual applications, sometimes we do not know the Oracle user password, but if we need to perform some operations with its users, however, you cannot modify the password of this user. At this time, you can use some tips to complete the operation.

The procedure is as follows:

 
 

  
  
SQL*Plus: Release 9.2.0.5.0 - Production on 
Copyright (c) 1982, 2002, Oracle Corporation.　
All rights reserved.  
  
  
SQL> connect sys/oracle as sysdba  
 
 

Connected.

 
 

  
  
SQL> select username,password from dba_users;  
  
  
USERNAME　 PASSWORD  
  
  
SYS8A8F025737A9097A  
  
  
SYSTEM 2D594E86F93B17A1  
  
  
DBSNMP E066D214D5421CCC  
  
  
TOAD　 A1BA01CF0DD82695  
  
  
OUTLN　4A3BA55E08595C81  
  
  
WMSYS　7C9BA362F8314299  
 
 

You have selected 6 rows.

 
 

  
  
SQL> connect system/oracle 
 
 

Connected.

 
 

  
  
SQL> connect sys/oracle as sysdba 
 
 

Connected.

Modify the Oracle user password. Change the system password to manager.

 
 

  
  
SQL> alter user system identified by manager; 
 
 

The user has changed.

 
 

  
  
SQL>　select username,password from dba_users;  
  
  
USERNAME　 PASSWORD  
  
  
SYS8A8F025737A9097A  
  
  
SYSTEM D4DF7931AB130E37  
  
  
DBSNMP E066D214D5421CCC  
  
  
TOAD　 A1BA01CF0DD82695  
  
  
OUTLN　4A3BA55E08595C81  
  
  
WMSYS　7C9BA362F8314299  
 
 

You have selected 6 rows.

 
 

  
  
SQL> connect system/manager 
 
 

Connected.

Then, you can perform any operations you want.

 
 

  
  
SQL> connect sys/oracle as sysdba 
 
 

Connected.

Change the user's system password to a previous value.

 
 

  
  
SQL> alter user system identified by values '2D594E86F93B17A1'; 
 
 

The user has changed.

 
 

  
  
SQL> connect system/oracle 
 
 

Connected.

 
 

  
  
SQL> connect sys/oracle as sysdba 
 
 

Connected.

 
 

  
  
SQL> connect system/manager  
  
  
ERROR:  
  
  
ORA-01017: invalid username/password; logon denied  
 
 

Warning: you are no longer connected to ORACLE.

The above content describes how to change the password of an Oracle user, hoping to help you in this regard.