Re: connect to another user

In Oracle 8i you can connect as a proxy user (if permitted) so that you can logon as another user without the password. However without this you can still save the user's password, reset it to something you know and then immediately set it back to the previous password. To do this you have to:

SELECT PASSWORD FROM DBA_USERS WHERE USERNAME = 'xxxxxx' ;

ALTER USER xxxxxx IDENTIFIED BY password ;

Connect as user xxxxxx using the password set above, then reset the password using

ALTER USER xxxxxx IDENTIFIED BY VALUES 'sssssssssssssss' ;

where ssssssssssssss is the password that you previously saved.

Obviously, this trick should only be used for good and not for evil.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!