Want to connect as a particular user but don’t know their password? You can temporarily change it and then reset it back, if you have DBA/alter any user privilege:
SQL> select password from dba_users where username = 'MYUSER'; PASSWORD ------------------------------ 086FAA387C794B46 SQL> alter user MYUSER identified by mypassword ; User altered. SQL> conn MYUSER/mypassword Connected. SQL> alter user MYUSER identified by values '086FAA387C794B46'; User altered. SQL> sho user USER is "MYUSER"
The above works for versions up to 10g. For 11g, instead use:
SQL> set long 9999
SQL> select dbms_metadata.get_ddl ('USER', 'MYUSER') from dual ;
Source: Laurent Schneider.