Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Altering passwords
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C08848.368FF200 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Altering passwordsHi Linda!
Have a look at my script GenUsers.SQL you can find on my web page at: http://www.materialdreams.com/scripts.html It should do the job.
DO
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Hagedorn,
Linda
Sent: Friday, January 26, 2001 11:06 PM
To: Multiple recipients of list ORACLE-L
Subject: Altering passwords
Hello,
I need to create a set of passwords on a new machine with the same passwords as on the old machine.
I'm looking for the passwords, but I remember someone here had a very clever way to alter user xx identified by 'xxxx' which was the encrypted string from dba_userids.
If anyone remembers or has that information, I'd appreciate it if you would send it to me or post it.
Thanks very much. Linda
------=_NextPart_000_0008_01C08848.368FF200 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Altering passwords</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4611.1300" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D371470009-27012001><FONT color=3D#0000ff size=3D2>Hi=20
Linda!</FONT></SPAN></DIV>
<DIV><SPAN class=3D371470009-27012001><FONT color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D371470009-27012001><FONT color=3D#0000ff =
size=3D2>Have a look at my=20
script GenUsers.SQL you can find</FONT></SPAN></DIV>
<DIV><SPAN class=3D371470009-27012001><FONT color=3D#0000ff size=3D2>on =
my web page=20
at: <A=20
href=3D"http://www.materialdreams.com/scripts.html">http://www.materialdr=
eams.com/scripts.html</A></FONT></SPAN></DIV>
<DIV><SPAN class=3D371470009-27012001><FONT color=3D#0000ff size=3D2>It =
should do the=20
job.</FONT></SPAN></DIV>
<DIV><SPAN class=3D371470009-27012001><FONT color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D371470009-27012001><FONT color=3D#0000ff=20
size=3D2>DO</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20
[mailto:root_at_fatcity.com]<B>On Behalf Of </B>Hagedorn, =
Linda<BR><B>Sent:</B>=20
Friday, January 26, 2001 11:06 PM<BR><B>To:</B> Multiple recipients of =
list=20
ORACLE-L<BR><B>Subject:</B> Altering passwords <BR><BR></FONT></DIV>
<P><FONT face=3DArial size=3D2>Hello, </FONT></P>
<P><FONT face=3DArial size=3D2>I need to create a set of passwords on =
a new=20
machine with the same passwords as on the old machine. =
</FONT></P>
<P><FONT face=3DArial size=3D2>I'm looking for the passwords, but I =
remember=20
someone here had a very clever way to alter user xx identified by =
'xxxx' which=20
was the encrypted string from dba_userids. </FONT></P>
<P><FONT face=3DArial size=3D2>If anyone remembers or has that =
information, I'd=20
appreciate it if you would send it to me or post it. </FONT></P>
<P><FONT face=3DArial size=3D2>Thanks very much. Linda=20
</FONT></P></BLOCKQUOTE></BODY></HTML>
Received on Sat Jan 27 2001 - 03:02:09 CST