To Change User Password In Oracle Database

Suppose we have 1 user called ‘testing’ in Oracle database. User ‘testing’ has the password ‘password’. User testing can change his own password by using this command :

oracle@mytestbed:~$ sqlplus testing/password

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 6 11:45:16 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> ALTER USER TESTING IDENTIFIED BY TESTING123;

User altered.

SQL> QUIT
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

If user try to login using old password then he will not able to login :

oracle@mytestbed:~$ sqlplus testing/password

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 6 11:45:54 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: ^C
oracle@mytestbed:~$ 

Login success if user ‘testing’ put the new password :

oracle@mytestbed:~$ sqlplus testing/testing123

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 6 11:47:07 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> 

Leave a Reply