Become User privilege

Is there a way a DBA can log on as other users (without saving the = encrypted
password, changing the password of the account, logging in using the = new
password, logging out, and restoring the original password)?

I see import uses a privilege called BECOME USER, is there any way I = can
invoke this priv from a SQL script?

I have a number of procedures, views, packages etc. that were coded = without
a schema specified in front of table and object names, and I can't = recompile
them as SYSTEM or using my DBA account, because Oracle substitutes my = schema
wherever a schema was not specified.

If I could use the BECOME USER privilege, I could run a script that = would
log in as each user, in turn, recompile all that user's object, then = move to
the next user, and so on.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20 Received on Tue Aug 29 2000 - 09:08:26 CDT