Random Character-PW Generator - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Random Character-PW Generator

Author

Topic

skillile
Posting Yak Master

208 Posts

Posted - 2002-03-11 : 16:01:01

I would like to create a random pw on the fly while
adding new users. Using A-Z and 0-9.

I am thinking of a table with all of these chars/ints in it
and then looping through on a random number to the lengh
desired on the pw.

Any other ideas would be appreciated.

slow down to move faster...

Jay99

468 Posts

Posted - 2002-03-11 : 16:16:29

There are many tools out there with very well thought out algorithms written already. Maybe you don't need to re-invent the wheel here.

Here are a couple links that may be helpful . .

http://dbforums.com/archive/68/2001/12/4/244179
http://www.4guysfromrolla.com/webtech/tips/t060500-1.shtml
http://security.isu.edu/isl/fips181.html

Jay

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2002-03-11 : 16:19:04

Not strictly SQL advice, but leave out 0 and O, I (or l) and 1 unless you can guarantee the passwords will be distributed in a font that makes the difference obvious.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources