Retrieve user password in Oracle How to obtain the password of a specified user in Oracle? What query to use to obtain that?
You cannot; Oracle does not store user passwords, only their hash values, which you can retrieve by select password from dba_users where username = 'WHATEVER'.