Searching for user passwords in Oracle
For obvious security reasons we can not see clear the password of the users of the database, but as an administrator user SYSTEM does have privileges to view the encrypted password:
SQL> select password from dba_users where username='SCOTT';
PASSWORD
-----------------------------
F894844C34402B67The usefulness of this is that as we return the SELECT can be used in a sentence of password change;
SQL> alter user scott identified by values 'F894844C34402B67';