AW: Become User privilege

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Tue, 29 Aug 2000 16:41:34 +0200
Message-Id: <10603.115734@fatcity.com>

You can use the alter session to change your current schema. Every = object
you create will be created in current schema.

alter session set current_schema=3D<schema where to create objects);

Hope this will help

Volker Sch=F6n
INPLAN RUHR
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de
=20

-----Urspr=FCngliche Nachricht-----
Von: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca] Gesendet: Dienstag, 29. August 2000 17:12 An: Multiple recipients of list ORACLE-L Betreff: 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

--=20
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). Received on Tue Aug 29 2000 - 09:41:34 CDT