Where Can One Reset Their Password For A Connection?
Last updated on OCTOBER 27, 2016
Applies to:Oracle SQL Developer - Version 1.5.4 to 18.104.22.168
Information in this document applies to any platform.
***Checked for relevance on 23-Aug-2011***
-- Problem Statement:
When creating a connection or using an existing connection in SQL Developer 2.1, where the
password to access the schema is expired, SQL Developer does not automatically present the end
user with an option to change and/or update the expired password.
An error was encountered performing the requested operation:
ORA-2800: the password has expired
Cause: The user's account has expired and the password needs to be changed
Action: change the password or contact the DBA
Vendor code 28001
-- Steps To Reproduce:
1) Create a user, or alter an existing user so that the password is set to expire:
ALTER USER user1 PASSWORD EXPIRE;
2) In SQL Developer, create a connection with no username or password.
3) Attempt to connect as that user and the error message will be raised.
NOTE: This test was performed with no username or password. If a username is provided in the
connection, the connection will fail due to NULL password, and does not communicate with the
database to determine if the password is valid or not.
The same test performed with username and (expired) password defined in the connection raises the
same error as reported above. But in this case even if the end user is prompted to change the
password in the database, the connection definition will still hold the expired password.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms