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

you can actually change their password to something that YOU know. So that you can logon to their schema and do whatever you want to do.

alter user <username> identified by <newpassword>;

if you don't want them to know that you have changed their password.. or you want to change the password back. get the encrpted password from dba_users (umm.. I hope that I am right about this view), and remember that "value".. When you want to change their password back.. issue:

alter user <username> identified by value '<the value go here>';

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.
>
>
>Thanks ....
>
>
>...jeff
Received on Fri Aug 28 1998 - 00:00:00 CDT