Re: OT: Password Generator...

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Thu, 21 Nov 2002 09:14:05 -0800
Message-ID: <F001.0050901A.20021121091405@fatcity.com>

>From Tom Kyte's site...

ops$tkyte_at_8i> declare
  2 function digest( p_username in varchar2, p_password in varchar2 ) return varchar2

  3      is
  4      begin
  5          return ltrim( to_char(

dbms_utility.get_hash_value(
upper(p_username)||'/'||upper(p_password),   6    1000000000, power(2,30) ),

  7                          rpad( 'X',29,'X')||'X' )
);
  8      end digest;
  9  begin
 10      for x in ( select username from all_users
where rownum < 20 )
 11      loop
 12          dbms_output.put_line( 'User: ' || rpad(
x.username , 30 ) ||
 13                                ' digest: ' ||
digest( x.username, 'TIGER' ) );
 14      end loop;

 15 end;
 16 /

User: SYS                            digest: 6869FA1A
User: SYSTEM                         digest: 79F08AFC
User: OUTLN                          digest: 5ABFB255
User: DBSNMP                         digest: 43415F6B
User: TRACESVR                       digest: 49CF26F6
User: CTXSYS                         digest: 4910C297
User: OEM                            digest: 69463BC2
User: ORDSYS                         digest: 6F048B2B
User: ORDPLUGINS                     digest: 6547459C
User: MDSYS                          digest: 43C0B367
User: AURORA$ORB$UNAUTHENTICATED     digest: 5073BBFC
User: WEB$CDEJESUS                   digest: 6FB5CDB6
User: SCOTT                          digest: 4307767C
User: WEB$SMAYFIEL                   digest: 71ED5065
User: UTILS                          digest: 5B7912B7
User: OAS_PUBLIC                     digest: 502BAE3A
User: WEBDB                          digest: 5A7AC149
User: WEB$RDRISCOL                   digest: 3E72D3F6
User: WEB$KWARREN                    digest: 7123F5A1

• "Loughmiller, Greg" <Greg.Loughmiller_at_cingular.com> wrote: > Hey folks-
  > I have a question that was presented to me by a web
  > development team..
  >
  > Does anyone know of products,procedures,etc that
  > would generate a random
  > password for a user? For example-similar to that at
  > MetaLink when you forget
  > your password-and they send you a new one that is
  > just a string of
  > characters/numeric digits...
  >
  > Thanks!
  >
  > Greg Loughmiller
  > Sr Manager - Enterprise Data Architecture
  > gloughmiller (IPS)
  > 678.893.3217 (office)
  >
  >
  >
  

  ---

Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"

---

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Nov 21 2002 - 11:14:05 CST