Oracle Forgot Password

What does Oracle forget about Sys/system/scott user's password?

A. Forget the login password for users other than SYS and system users.

Login with SYS (or system) User: CONN Sys/pass_word as SYSDBA;

Use the following statement to modify the user's password: ALTER user user_name identified by Newpass;

Note: Passwords cannot be all numbers. and cannot be a number start. Otherwise it will appear: ORA-00988: Password is missing or invalid

Second, forget the SYS user, or the password of the system user.

If you forget the password of the system user, you can log in with the SYS user. Then change the password with alter USER Chitian:

CONN Sys/pass_word as SYSDBA;

ALTER USER SYSTEM identified by Newpass;

If you are forgetting the password of the SYS user, you can log in with the system user. Then change the password with alter USER Chitian.

CONN System/pass_word;

ALTER USER SYSTEM identified by Newpass;

Third, if the Sys,system user's password is forgotten or lost.

This item is particularly important.

You can use the ORAPWD.EXE tool to modify the password.

Start menu, run as input ' CMD ', open a command Prompt window and enter the following command:

Orapwd File=d:\oracle\product\10.2.0\db_1\database\pwdctcsys.ora Password=newpass

This command regenerates the password file for the database. The location of the password file is under the \database directory in the Oracle_home directory.

This password is the password that modifies the SYS user. Passwords for other users except SYS and system will not change.

-----------------------------------users to authorize other users to read and write their own tables-----------------------------------------------

R user access to their own data table additions and deletions: Grant Select,delete,update,insert on EMP to Capucivar;

Oracle Forgot Password