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.
select dbms_metadata.get_ddl('USER','xUser') from dual;