Re: random password generation

In article <CrwJ94.9oz_at_mozo.cc.purdue.edu>, tmh_at_staff.cc.purdue.edu (Todd Helfter) wrote:

> Does anyone have a random password generation function (SQL)
> that they would be willing to post or e-mail?
>
> Im frustrated by a lack of a random number function.
>

me too.

what i have done is this:

  select 'X'||sum(gets)||userenv('sessionid') random from v$rowcache;

you need dba to do this. if you don't have dba, get your dba to make this into a view that public can select from.

obviously, this is not very random in any kind of mathemetical sense, but on a busy system it will generate a password that will be hard to guess unless someone is watching you do it, so that they know when you do it and can monitor the rowcache stats at the same time.

you could probably make this better depending on your exact situation.

anyone with a better solution please post!

sure would be nice if oracle would provide this. Received on Fri Jun 24 1994 - 19:33:49 CEST