At my site i have access to 6 database instances. Every three months i have to change passwords for each instance and as per rules, we have to use longer and complicated passwords. For changing password in one instance, I had to do the following
- Login to that instance using sqlplus, i had to enter existing password once
- Type Password
- Enter Old Password
- Enter New Password
- Enter New Password
- Login to database using sql developer
- Type following command
alter user user_name identified by "New_Password" replace "Old_Password";
Note: New_Password and Old_Password values should be in double quotes.
No comments:
Post a Comment