Re: Change User

There is a convoluted way to do it:
This all assumes u have dba role or at least access to sys.dba_users and the alter any user sys privilege.

1. spool reset.spl
2. select 'alter user '||username||' identified by values ' ||''''||password||''''||';' from sys.dba_users where username = 'USERNAME YOU WANT TO BECOME';
3. spool off
4. alter user username identified by newpassowrd;
5. connect username/newpassword
6. do what u need to do.
7. when all done @reset.spl

hope that helps, joe
http://www.oracle-dba.com

In article <6ind1i$hg7$1_at_stalker.oem.net>#1/1,   "Murtaza Doctor" <mdoctor_at_firstsense.com> wrote:
>
>
> Is there a way for a dba to change a login to another user
> - if he/she does not have the user password?
> (without logging off ofcourse).
>
> Sybase has the "setuser" command to do this.
>
> Thankyou.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 05 1998 - 15:11:42 CDT