RE: Altering passwords

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 26 Jan 2001 14:33:08 -0800
Message-Id: <10753.127667@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' ; Received on Fri Jan 26 2001 - 16:33:08 CST