How to change password and unlock for Oracle 11g users

This article uses easy-to-understand examples to introduce how Oracle 11g users change passwords and lock and unlock, the code is very detailed, interested friends can refer to, I hope it can be helpful to you.

1. Run cmd.exe

two。 Enter sqlplus / as sysdba to connect to the database as a system administrator (sysdba) for database management operations.

3. Execute after successful connection

Alter user identityName identified by password;-change password alter user identityName account unlock;-unlock alter user identityName account lock;-lock identityName: user to be modified; password: new password

Complete

PS: unlocking and locking for oracle 11g users (hr mode)

SQL > conn sys/sys as sysdbaConnected.SQL > show userUSER is "SYS" SQL > alter user hr account unlock; (unlock) User altered.SQL > alter user hr identified by * password*; (change password, this step is required, otherwise hr mode cannot be used) User altered. Hr mode is ready to use here, try: SQL > conn hr/*password*Connected.SQL > show userUSER is "HR"-the opposite SQL > alter user hr account lock; (locking) User altered.SQL > alter user hr password expire; (password invalidation) User altered.SQL > conn hr/*password*ERROR:ORA-28000: the account is lockedWarning: You are no longer connected to ORACLE.

Have you learned it? You can try it yourself.

About Oracle 11g users how to change the password and lock and unlock to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.