Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle equivalent to unix 'su - username'... connecting as someone else

Re: Oracle equivalent to unix 'su - username'... connecting as someone else

From: Serguei Kroutiakov <serge_at_idirect.ca>
Date: 1998/08/28
Message-ID: <35e7727b.0@nemo.idirect.com>#1/1

oracle_at_nettwerk.com wrote in message <35E752AE.BC25E2E9_at_nettwerk.com>...
>Hi there-
>
>I was wondering if anyone could possibly help me...
>
>I have been granted DBA privs on an Oracle 8.0.5 database, and after
>connecting as DBA, would like to connect as another user in that database...
>but I don't want to have to know their password.
>
>Similar to 'su - username' as root on a unix box.
>
>Any ideas?
>
>I have to do some work in some schemas while a couple of people are on
>vacation (no passwords!), and I can't just change the password without
>breaking some other things like OAS links, etc. Being able to "su" would be
>way easier.

I think this is the answer
http://www.orafaq.org/faqdba7.htm#BECOMEUSER



Regards,

Serguei Received on Fri Aug 28 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US