Password Generation
186630Aug 17 2005 — edited Aug 22 2005Dear All
I have a requirement for a function that can automatically generate alpha-numeric passwords randomly for users. I have a table for user authentication where stores username, passwords, date of expiry....etc for all my users. I need to write a function that on password expiry it can automatically generate a random 6-digit password for the user.
like for example:
select random(t.user_name)
from sec_user t
where user_name = 'ABCuser';
it should return a random password like "xc12b9" or it may return "yg907r".
Regards.