help:login as another schema

Sometimes, I need to login as another schema in order to explain plan for some statements. When I looked at dba_users, the password is something like A375439DC97, etc. Is there any way we can use this encrypted password to login as another schema? Or I have to get the real password to do that, which changes frequently?

Or is there anything like 'alter session set current_user = another scchema' so that I can run explain plan?

Thanks for your help. Received on Sat Feb 23 2002 - 12:21:01 CST