A trick to modify Oracle user passwords

Oracle
A trick to modify Oracle user passwords

Database version: 9.2.0.5



Sometimes we may not know a user's password, but also need to do some operations with this user, and can not modify the user's password, this time, you can use some tips to complete the operation.

The specific procedures are as follows:

Sql*plus:release 9.2.0.5.0-production on Sunday November 21 13:32:34 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Sql> Connect sys/oracle as Sysdba

is connected.

Sql> select Username,password from Dba_users;

USERNAME PASSWORD

------------------------------ ------------------------------

SYS 8a8f025737a9097a

SYSTEM 2D594E86F93B17A1

Dbsnmp E066D214D5421CCC

TOAD a1ba01cf0dd82695

Outln 4a3ba55e08595c81

Wmsys 7c9ba362f8314299

6 rows have been selected.

Sql> Connect system/oracle

is connected.

Sql> Connect sys/oracle as Sysdba

is connected.

Modify user System password to Manager

sql> alter user system identified by manager;

The user has changed.

Sql> select Username,password from Dba_users;

USERNAME PASSWORD

------------------------------ ------------------------------

SYS 8a8f025737a9097a

SYSTEM d4df7931ab130e37

Dbsnmp E066D214D5421CCC

TOAD a1ba01cf0dd82695

Outln 4a3ba55e08595c81

Wmsys 7c9ba362f8314299

6 rows have been selected.

Sql> Connect System/manager

is connected.

Then you can do whatever you want to do at this point.

Sql> Connect sys/oracle as Sysdba

is connected.

Modify user system password to previous value

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

The user has changed.

Sql> Connect system/oracle

is connected.

Sql> Connect sys/oracle as Sysdba

is connected.

Sql> Connect System/manager

ERROR:

Ora-01017:invalid Username/password; Logon denied

Warning: You are no longer connected to ORACLE.