OraFAQ Forum: Security » using pl/sql for generating random password

Home » RDBMS Server » Security » using pl/sql for generating random password

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

using pl/sql for generating random password [message #41995]

Thu, 20 February 2003 09:54

lboss
Messages: 1
Registered: February 2003

Junior Member

I am trying to generate random passwords for users
using pl/sql. Does anyone have sample code that generates random passwords

thanks

Report message to a moderator

Re: using pl/sql for generating random password [message #42011 is a reply to message #41995]

Fri, 21 February 2003 03:22

Keith
Messages: 88
Registered: March 2000

Member

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:98812348060

http://www.orafaq.net/msgboard/plsql/messages/9581.htm

Report message to a moderator

Re: using pl/sql for generating random password [message #42043 is a reply to message #41995]

Mon, 24 February 2003 13:54

pbujold
Messages: 10
Registered: February 2003

Junior Member

Have a look at the dbms_random package utility

i.e.
l_pass := dbms_random.string(opt => 'l', len => 8);

different opt values are:
'u' -- upper case alpha characters only
'l' -- lower case alpha characters only
'a' -- alpha characters only (mixed case)
'x' -- any alpha-numeric characters (upper)
'p' -- any printable characters

Report message to a moderator

Previous Topic:	Fine-Grained auditing
Next Topic:	Audit Trail

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 02 14:59:42 CDT 2025