RE: Become User privilege

You could actually do what you want to do without logging on as that user. One method is get a copy of Toad. I do most of my stuff signed in as the DBA including recompling the packages of other users. But if you truly want to do the whole schema user a dynamic script where you pick the owner and name from the dba_objects table. Simple and you never have to update a script when a new package is added.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Boivin, Patrice J
Sent: Tuesday, August 29, 2000 8:12 AM
To: Multiple recipients of list ORACLE-L Subject: 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èmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>

--
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).