become_user.sql

-- become_user.sql
-- Andy Barry
-- 15/05/06

set lines 999 pages 999
set verify off
set feedback off
set heading off

accept username prompt 'Enter username: '

spool /tmp/become_user.sql

select 'alter user &username identified by values ''' || password || ''';'
from dba_users
where username = '&username'
/

spool off

alter user &username identified by p4r32rnw
/

conn &username/p4r32rnw

@/tmp/become_user.sql

select 'Connected as ' || user from dual;

!rm /tmp/become_user.sql

set verify on
set feedback on
set heading on