Re: Q: Become user
From: <stowe_at_mcs.net>
Date: 1995/05/27
Message-ID: <3q6f06$319_at_News1.mcs.com>#1/1
Date: 1995/05/27
Message-ID: <3q6f06$319_at_News1.mcs.com>#1/1
> chris_at_perihelion.co.uk (Chris Selwyn) writes:
>
> Does anyone know of a method for a user with DBA privileges to "Become"
> another user temporarily?
>>>>
Yep. Not that it's easy -- use this script:
REM - become another user
REM
set pagesize 0 feedback off verify off echo off termout off
spool chg2usr.sql
SELECT 'alter user &&1 identified by values '||''''||password||''''||';'
FROM dba_users WHERE username = upper ('&&1');
REM the line below is platform-specific
prompt 'host rm -f chg2usr.sql'
prompt 'exit'
spool off
exit
run it, and it should do as you ask. :)
Michael Stowe
Constellation Engineering, Inc.
http://www.mcs.com/~stowe
Received on Sat May 27 1995 - 00:00:00 CEST