How to restore the use of expired user passwords in the database without changing the password

This article is about how users' passwords in the database can be restored without changing their passwords. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. Use the DBA database privileged user to view the user's current profile

SQL > select username,profile from dba_users where username = 'username'

USERNAME PROFILE

--

USERNAME DEFAULT

two。 Create a temporary profile

Create profile temp_prof limit

PASSWORD_REUSE_MAX unlimited

PASSWORD_REUSE_TIME unlimited

3. Assign this temporary profile to the user

SQL > alter user username profile temp_prof

4. Check the password that caused the confusion:

SQL > select password from user$ where name = 'username'

PASSWORD

-

Xxxxxxxxxxxxx

5. Use the original password to set the new password for the account, which can make the expired password take effect again.

SQL > alter user username identified by value 'xxxxxxxxxxxxx'

6. Reassign the original profile to the user:

SQL > alter user username profile default

Thank you for reading! This is the end of the article on "how to restore the use of user passwords in the database without changing their passwords". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!