RE: Altering passwords

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 26 Jan 2001 14:33:08 -0800
Message-Id: <10753.127668@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_01C087E7.F4EB9990
Content-Type: text/plain;

charset="iso-8859-1"

>-----Original Message-----
>From: Hagedorn, Linda [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_01C087E7.F4EB9990
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2652.35">
<TITLE>RE: Altering passwords </TITLE>
</HEAD>
<BODY>

>-----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.  


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
Received on Fri Jan 26 2001 - 16:33:08 CST