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

Here's a way but you take your chances.

Copy the encrypted user password to notepad. Alter user change the password
Do your work
Do this command

    Alter user USERNAM identified by values 'paste back the encrypted password';

In particular note the single quotes around the pasted in password and the keyword values.

Van

Or for a more proper way search this site and find Thomas Kyte's reply to a query of mine last week. How shows a workaround that is more complicated but a lot safer.

yewpc_at_my-dejanews.com wrote in message <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.
>
> Anyone have any idea ?
> Thankz in advance...
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Jan 28 1999 - 16:44:19 CST