Re: Is there a way to connect to a user that password is unknow ?

From: Valery Yourinsky <vsu_at_softexpress.ru>
Date: Thu, 28 Jan 1999 13:29:50 +0300
Message-ID: <36b03c1e.0@192.168.2.10>

yewpc_at_my-dejanews.com пишет в сообщении <78p2t4$j61$1_at_nnrp1.dejanews.com> ...
>Hi,
> I would like to temporary connect to a user that I don't
> know the password. Is there a way to do that ?
>
> The only way I can think of is to alter the user password but
> by this way I will not be able to set back the user original
> password.

   If you have DBA role you can
SELECT USERNAME,PASSWORD
FROM dba_users
WHERE username = 'SCOTT'
/
USERNAME PASSWORD

-------- ----------------

SCOTT F894844C34402B67 ALTER USER scott IDENTIFIED BY newpassword /

Temporary connect to a user.....

Set old password back

ALTER USER scott IDENTIFIED BY VALUES 'F894844C34402B67' /

Valery Yourinsky Received on Thu Jan 28 1999 - 04:29:50 CST