Easily fix Oracle user password changes

We assume that in such an application scenario, the database needs to be transplanted and the Oracle user password of a user in the database is unknown. However, this password cannot be modified because it is used in other programs, in the new database system, the Oracle user password must be the same as the original password. A headache!

In this case, the usual method is not acceptable. View the information to obtain the method modified below.

Query the ciphertext of an Oracle user password

 
 

  
  
SQL> select username,password from dba_users where username=\'JW_PUB1\';  
  
  
 
  
  
USERNAME PASSWORD 
  
  
------------------------------ ------------------------------  
  
  
JW_PUB1 1141B75987409AA1  
  
  
 
  
  
SQL> select username,password from dba_users where username=\'PORTAL\';  
  
  
 
  
  
USERNAME PASSWORD 
  
  
------------------------------ ------------------------------  
  
  
PORTAL A9B80747F4D3AF98  
  
  
 
  
  
SQL>   
 
 

Change Password

 
 

  
  
SQL> alter user jw_pub1 identified by values \'1141B75987409AA1\';  
  
  
 
  
  
User altered.  
  
  
 
  
  
SQL> alter user portal identified by values \'A9B80747F4D3AF98\';  
  
  
 
  
  
User altered.  
 
 

Now that the Oracle user password is modified, you can test whether the verification program is successful.

1. How to unlock users in Oracle
2. Oracle System Administrator notice: Role permission management
3. Authorization and management for five Oracle users
4. Step 4: Change the Oracle user name
5. Two-step Oracle user tablespace proficiency