equivalent of su in oracle?

On unix, the root user can become any user without knowing the user's password.
I don't know such a feature in oracle. That is, even if system user has dba priviledge,
I still need to do connect user/password to become another user. This is very
inconvenient if you have a lot of schemas. One can of course temporarily

change the schema's password and later change it back. But this troublesome.

Does anyone know a way in oracle to let the system user become any user without knowing the users' password?

Thanks for any info.

Richard Received on Sat Jul 22 2000 - 00:00:00 CDT