-- -----------------------------------------------------------------------------------
-- File Name : http://www.oracle-base.com/dba/script_creation/logon_as_user_orig.sql
-- Author : Tim Hall
-- Description : Displays the DDL for a specific user.
-- Call Syntax : @logon_as_user_orig (username)
-- Last Modified: 28/01/2006
-- -----------------------------------------------------------------------------------
set serveroutput on verify off
declare
l_username VARCHAR2(30) := upper('&1');
l_orig_pwd VARCHAR2(32767);
begin
select password
into l_orig_pwd
from dba_users
where username = l_username;
dbms_output.put_line('--');
dbms_output.put_line('alter user ' || l_username || ' identified by DummyPassword1;');
dbms_output.put_line('conn ' || l_username || '/DummyPassword1');
dbms_output.put_line('--');
dbms_output.put_line('-- Do something here.');
dbms_output.put_line('--');
dbms_output.put_line('conn / as sysdba');
dbms_output.put_line('alter user ' || l_username || ' identified by values '''||l_orig_pwd||''';');
end;
/
