RE: Altering passwords

From: Hagedorn, Linda <lindah_at_epocrates.com>
Date: Fri, 26 Jan 2001 14:44:41 -0800
Message-Id: <10753.127671@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C087E9.9208BDB0
Content-Type: text/plain;

charset="iso-8859-1"

Thankyou so much!!! That was it.

And thank you for the example.

Best regards, Linda

-----Original Message-----
From: Jacques Kilchoer [mailto:Jacques.Kilchoer_at_quest.com] Sent: Friday, January 26, 2001 2:34 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Altering passwords

>-----Original Message-----
>From: Hagedorn, Linda [ mailto:lindah_at_epocrates.com
<mailto:lindah_at_epocrates.com> ]
>Sent: vendredi, 26. janvier 2001 14:06
>
>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.

alter user xx identified by values 'xxxx' ;

see example below.

SQL> create user nigel identified by secret default tablespace users temporary tablespace temp ;

User created.

SQL> grant create session to nigel ;

Grant succeeded.

SQL> -- allow nigel to look at dba_users SQL> grant select any table to nigel ;

Grant succeeded.

SQL> connect nigel/secret
Connected.
SQL> select password from dba_users where username = 'NIGEL' ;

PASSWORD

E8D3F9548D8BA445

SQL> alter user nigel identified by new_pass ;

User altered.

SQL> connect nigel/new_pass
Connected.
SQL> alter user nigel identified by values 'E8D3F9548D8BA445' ;

User altered.

SQL> connect nigel/secret
Connected.
SQL> ------_=_NextPart_001_01C087E9.9208BDB0
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Altering passwords</TITLE>

<META content="MSHTML 5.50.4522.1800" name=GENERATOR></HEAD>

<BODY>
<DIV>Thankyou so much!!!  That was it.   </DIV> <DIV> </DIV>
<DIV>And thank you for the example.  </DIV> <DIV> </DIV>
<DIV>Best regards, Linda </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader>-----Original Message----- From: Jacques Kilchoer [mailto:Jacques.Kilchoer_at_quest.com] Sent: Friday, January 26, 2001 2:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: Altering passwords </DIV> >-----Original Message----- >From: Hagedorn, Linda [<A
href="mailto:lindah_at_epocrates.com">mailto:lindah_at_epocrates.com</A>] >Sent: vendredi, 26. janvier 2001 14:06 > >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.

  </FONT></P>
  <P><FONT size=2>alter user xx identified by values 'xxxx' ;</FONT> </P>
  <P><FONT size=2>see example below.</FONT> </P>
  <P><FONT size=2>SQL&gt; create user nigel identified by secret default

tablespace users temporary tablespace temp ;

  <P><FONT size=2>User created.</FONT> </P>
  <P><FONT size=2>SQL&gt; grant create session to nigel ;</FONT> </P>
  <P><FONT size=2>Grant succeeded.</FONT> </P>
  <P><FONT size=2>SQL&gt;&nbsp; -- allow nigel to look at dba_users</FONT> 
  <BR><FONT size=2>SQL&gt; grant select any table to nigel ;</FONT> </P>
  <P><FONT size=2>Grant succeeded.</FONT> </P>
  <P><FONT size=2>SQL&gt; connect nigel/secret</FONT> <BR><FONT

size=2>Connected. SQL> select password from dba_users where username = 'NIGEL' ; PASSWORD <FONT

  size=2>------------------------------</FONT> <BR><FONT

size=2>E8D3F9548D8BA445

  <P><FONT size=2>SQL&gt; alter user nigel identified by new_pass ;</FONT> </P>
  <P><FONT size=2>User altered.</FONT> </P>
  <P><FONT size=2>SQL&gt; connect nigel/new_pass</FONT> <BR><FONT

size=2>Connected. SQL> alter user nigel identified by values 'E8D3F9548D8BA445' ; User altered. SQL> connect nigel/secret Connected. SQL> Received on Fri Jan 26 2001 - 16:44:41 CST