Tips for Oracle database users

Guidance:Sometimes we may not know the password of a user, but we need to perform some operations as this user, and we 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 Sunday November 21 13:32:34 2004

Copyright c) 1982,200 2, Oracle Corporation. All rights reserved.

SQL connect sys/oracle as sysdba

Connected.

SQL select username, password from dba_users;

USERNAME PASSWORD

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

SYS 8A8F025737A9097A

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.

Change 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

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.

This is the tip I want to introduce to you. It can only be used in formal work and cannot be maliciously damaged. I hope you can exercise caution when selecting this item.