Re: Q: Become user

> chris_at_perihelion.co.uk (Chris Selwyn) writes:
> stowe_at_mcs.net wrote:
> : > chris_at_perihelion.co.uk (Chris Selwyn) writes:
> : >
> : > Does anyone know of a method for a user with DBA privileges to "Become"
> : > another user temporarily?
> : >>>>
 

> Two problems with this method :-
> 1) The user is left with a different password than their original one.
> Does anyone know how to restore the original password?

Actually, the script provided DOES restore the original password -- that was the whole point. However, the password is changed temporarily. (The impact may be minimized by running the script from another process to change the password back while still logged on as the user.)   

> 2) Even if it is possible to restore the original password - the user
> has a different password temporarily which (as someone else has noted)
> messes up links from remote databases.

This only messes up links to the specific account, of course, and only those links that are made during the time that the password is temporarily changed.   

> Any suggestions?

Nope. :)

>>>>
Michael Stowe
Constellation Engineering, Inc.
http://www.mcs.com/~stowe Received on Mon May 29 1995 - 00:00:00 CEST