Monday , May 20 2024

How To Get User’s Password With Hash On Oracle 12c


In this article, I will show you how to get a user’s create script in Oracle12c, with the hash of the password.

We may need this process to remove the expiration of users who have expired passwords.

For details, you can read the article “ORA-28001: the password has expired“.

If you wnt to get user script in Oracle 12c, you will get a script like below instead of hash of password.


In Oracle 12c you can use the following script to get the user script.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *