Re: DBA logging in as a user.

Kevin Kinney wrote:
>
> I need to log in as a user to do some trouble shooting, and I know I've
> seen the procedure in the documentation, but I can't find it anywhere.
> Can someone help me out?

This is goto.sql. You run it in SQL*Plus from an account that has ALTER USER privilege.

--
set termout off
set echo off

col password new_value oldpswd noprint

select password from sys.dba_users
 where username = upper('&&1');

alter user &&1 identified by temppw;

connect &&1/temppw

alter user &&1 identified by values '&&oldpswd';

column password clear
set termout on
show user


-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com