How To Change/Restore User Password in 11 G

Oracle 11g introduces Case-sensitive passwords for database authentication. Along with this if you wish to change the password (temporarly) and reset it back to old, you will find that password dield in dba_users is empty. prior to 11g we could use following technique to change/restore password.

SQL > Create user amit identified by amit;                                                        User created.                                                                                     SQL > grant create session to amit;                                                               grant succeeded                                                                                   SQL > Conn sys as sysdba                                                                          Enter Password: XXXX                                                                              Connected.                                                                                        SQL > select username, password from dba_users where username='Amit';                                                                              Username                      Password                                                            ----------------             ------------------- AMIT                         9des222ss                                                            SQL > after user amit identified by abc;                                                          user altered                                     SQL > conn amit/abc                              Connected                                        SQL > conn sys as sysdba                         Enter Password                                   Connected.

SQL> alter user amit identified by values '9DEC0D889E8E9A6B';

User altered.

SQL> conn amit/amit

Connected.

Share on Google Plus

About Unknown

Nama saya adalah Gifari Alfan Reza, seorang yang tak luput dari kesalahan dan juga membutuhkan orang lain dalam menjalani hidup ini karena manusia tidak sendiri. Saya yang berkeinginan bisa pergi keluar negeri itu sangat itu aku inginkan "Bersemangatlah field in the user admin panel.