##  DBA Command Post - DBA_connect.sql


column password new_value _password_
accept usercode char prompt ’Connect to Usercode : ’

select password
from   sys.dba_users
where  username = upper(’&usercode’)
/

alter user &usercode identified by _temp_password_
/

connect &usercode/_temp_password_

alter user &usercode identified by value ’&_password_’
/