>From Tom Kyte's site... ops$tkyte@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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
