Menu
I have just tried to login to my db via sql developer as system so i can create a new user. It has come with an error that the password has expired.
I have googled a bit but cannot see how to reset the system user password. I guess this is a security issue.
My problem is how can I log in as system if the password has expired? How can I unexpire the password without logging in as System users. I seem to be stuck here in a loop where I cannot reset the password expiration.
619
If you receive a Your password has expired message it means that your password has reached its age limit and expired. In other words, the password has been in use for too long and you must choose a new password at this time.
You need to open Active Directory Users and Computers, and you need to have 'Advanced options' enabled. Locate your user and open their properties > Attribute Editor > Attributes > pwdLastSet. If you want to set it to expired, then set its value to Zero.
Open up cmd.exe and type in SQLPLUS
Enter user-name: SYSTEM Enter password: the expired password It will now let you type in a new password for the SYSTEM user
164
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
