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>