Message-Id: <10753.127671@fatcity.com> From: "Hagedorn, Linda" Date: Fri, 26 Jan 2001 14:44:41 -0800 Subject: RE: Altering passwords 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@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@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" RE: Altering passwords
Thankyou so much!!!  That was it.  
 
And thank you for the example. 
 
Best regards, Linda
-----Original Message-----
From: Jacques Kilchoer [mailto:Jacques.Kilchoer@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@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>